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 for 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
  • Custom
Format

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

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.

...