Versions Compared

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.

Default format type is Text.

Available Data Types:

  • Text - format the value as text
  • Numeric - accepts a numeric value (See Format documentation)
  • 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
  • File
  • Image
  • Hidden
  • Custom
Format

Defines the format to show data on the spreadsheet based on the chosen format type.

  • Numeric - Key in format accepted by numbrojs library.
  • Date - Key in format accepted by moment.js  library.
  • Time - Key in format accepted by moment.js library.
  • Dropdown - Key in Form ID that contains the equivalent dropdown element.
  • Autocomplete - See handsontable for samples.
  • File- Key in Form Def ID that contains File Upload form element.
  • Image - Key in Form Def ID that contains Image Upload form element.
  • Hidden - Key in default value to be saved.
  • Custom - See handsontable for samples.
Regex ValidationValidates input value to match the defined Regular Expression pattern.
Formula

Defines a formula to perform processing.

Info
titleSample

Example: sales + profit-loss

 

 

ReadonlyDefines if the column is editable.

...