...
| Name | Description |
|---|
| Spreadsheet | Element ID of the form element. |
| Label | | Columns | Spreadsheet label/title. |
| Columns | The spreadsheet column(s) is defined here. | Sub-element | Description |
|---|
| Value | Field ID of the column. | | Label | Column 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
| | Regex Validation | Validates input value to match the defined Regular Expression pattern. | | Formula | Defines a formula to perform processing. Refer to Figure 1 & Figure 2 for a simple example. | | Readonly | Defines if the column is editable. |
|
Figure 3 : Spreadsheet Form Element Properties - UI
...