Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Create multiple simple forms with a 'Name' text field with no Advance Options configuration to create an option data list for the spreadsheet.

...

Create a 'Country' Form with the same configuration as Figure 1 , but with an addition of the 'Climate' and 'Continent' select box boxes which will be using the Form Data Options Binder on the 'Continent' select box field to load data from the 'Continent' Form.

...

Figure 2: Configure Form Data Options Binder

As shown in figure Figure 2, use the same configuration on the 'Climate' select box. Using Form Data Options Binder, the 'Continent' field will view the values from the Continent List that contains only one column "Name", and the Climate field will view the values from the Climate List that contains only one column "Name".

...

Create 'Address' Form with all the previous form forms as a select box with 'Continent', 'Climate', and 'Country' with the same configuration in Figure 2. But with additional configuration for the 'Country' select box.

Figure 3: Configure Country as Data Option Form

The Country field will view the values from the Country List under the Name column based on the grouping by the other 2 columns "Continent ", and "Climate" with the help of the 'use AJAX for Cascade Options?' checkbox.

...

Figure 4: Shows the multiple dependency fields of Country Field 

Warning

The Field Id ID to Control Available Options Based on Grouping the Grouping Field (figure 94)  must be in the same order as the order in the Grouping Column (figure 83).


Make sure to click on the Field Ids IDs rather than type them. You should only be typing the ';' symbol.


Create a form with a Spreadsheet field and populate it with form option data from the 'Address' Form. It is important for 'Country', 'Continent', and 'Climate' to be formatted as 'address' which contains the dropdown format containing the equivalent data. For more information on Spreadsheet Properties.

Image Removed

Image Added

NameDescription
Columns

The spreadsheet column(s) is defined here.

Sub-elementDescription
Field IDField 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'.

Field IDColumn Configuration
name

Image Removed

continent

Image Removed

climate

Image Removed

country
Image Removed

Figure 5: Spreadsheet configuration

...

Spreadsheet in app Run Time

Figure The figure below is the example data of which Country will appear based on the Climate and Continent combination. 

...

Figure 6: Example Form Data option


In the app run time, we can see the 'Country' column have has options when the combination is Asia and Tropical and none for Asian and Seasonal. 

...