...
| Name | Description |
|---|
| Columns | The spreadsheet column(s) is defined here. | Sub-element | Description |
|---|
| Field ID | Field ID of the column. | | Label | Column header title/label. | | Format Type | Columns 'Continent', 'Climate', and 'Country' will be using: Dropdown - appears as a dropdown menu to select options Column 'Name': Text - format the value as text or numbers. | | Format | Key in the Form Def ID that contains the equivalent dropdown element, in this case - 'address' For columns 'Continent', 'Climate', and 'Country'. |
|
Figure 5: Spreadsheet configuration
Spreadsheet in
...
App Run Time
The figure below is the example data of which Country will appear based on the Climate and Continent combination.
...