Joget Form Builder allows you to dynamically change the options/selections of a select box/radio button/radio, In this use case, multiple form field values from another form will populate a spreadsheet.

Tips

Dynamic Cascading Drop-Down List is also supported in List Filters.

How it works

Each option in the spreadsheet is a list of data from another form with an option binder configuration. Below will show the steps of configuring each form and spreadsheet.

Configuring spreadsheet cascading drop-down list

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

In this example, we will create 'Climate' and 'Continent' forms with the same configuration.

Figure 1: Configuring Form Data Options

Create a 'Country' Form with same configuration as Figure 1, but with an addition of 'Climate' and 'Continent' select box which will be using 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 2, use the same configuration on 'Climate' select box. Using Form Data Options Binder, 'Continent' field will view the values from the Continent List that contains only one column "Name", Climate field will view the values from the Climate List that contains only one column "Name".

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

Figure 3: Configure Country as Data Option Form

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 'use AJAX for Cascade Options?' checkbox.

Figure 4: Shows the multiple dependency fields of Country Field

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

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

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.