Last Updated: March 18, 2021

The Cascading form element allows you to show items based on information from the previous entries. It's configuration properties are composed of the following:

Field ID
Place Holder
Dataset
Returned Column
Searchable Column
Form Control Lookup



PREREQUISITE

Before we can configure the cascading element, we should design tables either on Master Table or Records Management. For example, let us create tables for country and city.

The first table we are going to create is the Country table. This table is just a normal and plain table. Add data to it once it is published.



The second table is the City table which will be linked to the country table. For this, we must first add a normal City column. Next, add another two columns and name them as Linked Country Name and Linked Country ID. The last two columns mentioned are which will be linked to the first table.



Let us begin configuring the Linked Country Name column.

Step 1: In order to link a specific table to another, you must enable the Has Lookup function.
Step 2: Select Data Source as the Key Configuration
Step 3: Select DDM as the data source. A field will appear where you must select the table you are going to link the second table to. In this case, select the first table we created, which is the Countryv1 table as the table name.



The Key Column is the value that will be saved on the database, while the Display Value will simply display the data. For this, we will use both ID and Display value for reference.

Linked Country Name
Key Column = Country
Display Column = Country

Linked Country ID
Key Column = ID
Display Column = Country

Linked Country Name
Linked Country ID

CONFIGURING THE CASCADING ELEMENT

After successfully creating the second table, add data to it and proceed with designing a form.

Step 1: Add a column and drag a normal dropdown element. This will be the head of the cascading element. Then you can add as many columns with cascading elements as you want, depending on what you need in the form.
Step 2: Configure the dropdown element. Let us define it as Country.
Step 3: Tick the box beside Use External Dataset. In the Dataset field, select the country table we created before and select Country as its Display column.
Step 4: Save it and let us configure next the cascading element. Let us define this one as City.
Step 5: Select the City table for the Data Set, as select City as the returned column. Since the Country uses ID as value, we will use the linkedCountryId as the searchable column, and Country as the Form Control Lookup. Save it and check out its web preview.

When you click the country field, it will list down all the data you have in the country table, and the city field will list down the corresponding data based on what you entered on the country field.



RELATED ARTICLE(S):
Default and System Form Elements

Need more help? Send us an email at customersuccess@quickreach.co, or send us a message on the chat widget.
Was this article helpful?
Cancel
Thank you!