...
Create a form with Spreadsheet field and populate with form option data from 'Address' Form. It is important for 'Country', 'Continent' and 'Climate' formatted as 'address' which contains the dropdown format containing the equivalent data. For more information on Spreadsheet Properties.
| Field ID | Column Configuration |
|---|---|
| name |
|
| continent |
|
| climate |
|
| country |
|
Figure 5: Spreadsheet configuration
...
Figure below is the example data of which Country will appear based on the Climate and Continent combination.
Figure 56: Example Form Data option
...
In app run time we can see 'Country' column have options when the combination is Asia and Tropical and none for Asian and Seasonal.
Figure 57: Spreadsheet Form Data Options testing
Demo App
| View file | ||
|---|---|---|
|
|
|