| Sub-element | Description |
|---|
| Value | Field ID of the column. |
| Label | Column 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 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. |