Versions Compared

Old Version 7

changes.mady.by.user Justin

Saved on

compared with

New Version 8

changes.mady.by.user Justin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NameDescription
SpreadsheetElement ID of the form element.
LabelSpreadsheet label/title.
Columns

The spreadsheet column(s) is defined here.

Sub-elementDescription
ValueField ID of the column.
LabelColumn header title/label.
Format Type

Defines the type of input to store.

Format

Defines the format to show data on the spreadsheet.

Default format type is Text.

Available Data Types:

  • Text - format the value as text
  • Numeric - accepts a numeric value
  • Date - accepts a date type value
  • Time - accepts a time type value
  • Checkbox - appears as a checkbox to check
  • Dropdown - appears as a dropdown menu to select options
  • Autocomplete - autocompletes any known phrases
  • Password - obscures any alphanumerical value into a password
  • Custom
Format

Defines the format to show data on the spreadsheet.

Regex ValidationValidates input value to match the defined Regular Expression pattern.
FormulaDefines a formula to perform processing. Refer to Figure 1 & Figure 2 for a simple example.
ReadonlyDefines if the column is editable.

...

NameDescription
Enable Header Sorting? Determines if users can sort spreadsheet data by column in ascending or descending order.
Data Order Field ID Field to keep the ordering sequence. Must correspond with a field id in the target form.
Readonly Defines if the entire spreadsheet is editable.
Disable Add Feature Determines if a new row can be added.
Disable Delete Feature Determines if a row can be removed.
Show Row Numbering? Show additional column on the leftmost to denote numbering.
Number of columns to fixed on left 
Number of spare rows 
Custom Settings (JSON) 

...

 

NameDescription
Validator 

Attach a Validator plugin to validate the input value.

Info
titleWhen will validation takes place?

Validation will takes place whenever form is submitted except when it is submitted as "Save as Draft".

Min Number of Row Validation (Integer) Defines the minimum number of rows required for input.
Max Number of Row Validation (Integer) Defines the maximum number of rows possible for input.
Error Message Error message to be shown when row requirements set above is not met.
Load Binder Option by default. Grid data will be saved/loaded in JSON format in its defined database cell.
Store Binder Option by default. Grid data will be saved/loaded in JSON format in its defined database cell.