Dropdown Binding

To create a dynamic and binding Dropdown functionality where the options of the second dropdown list are filtered based on the value selected in the first dropdown.

Expected output:

1st Step

  1. Begin by adding a blank transaction form.

2nd Step

  1. Add the first dropdown with database field name, label, width, etc. The database field name you want to use must be unique in that form. We are using 'OrganizationId' here.

3rd Step

  1. In the API Data tab, configure the API for Dropdown data binding. Please refer to the screenshot.

4th Step

  1. In the Rule section, enable 'Allow Binding with Other Controls,' set Control Properties to 'Filter,' and Control Type to 'Dropdown.' Add the Control Key. In the Control Key, enter the database field name for the second dropdown, which should filter the data (Second Dropdown). Now, set the API binding field to the database field name of the current dropdown we are configuring (First Dropdown). In this example, we are using 'ContactId' as the Control Key and 'OrganizationId' in the API. Click Confirm to save the dropdown configuration.

5th Step

  1. Add the second dropdown with database field name, label, width, etc. The database field name you want to use must be unique in that form. We are using 'ContactId' here.

6th Step

  1. In the API Data tab, configure the API for dropdown data binding and enter the query for data and filter. Please refer to the screenshot.

7th Step

  1. Click 'Confirm' to save the Dropdown configuration. Now, when you select an option in the first dropdown, the data in the second dropdown will be filtered accordingly.

Final Output: