Populate values in drop downs based on previous user selections

Hi

I am working on version 16.2.

I have the below requirement to be fulfilled.
1st user selects a country from a drop down (whose values are being populated from a constant).
Now based on user's country selection, a list of regions should be fetched from backend and this should be displayed in a new drop down called "Regions" under the "Country" drop down.
Next when user selects a region, then based on the combination of country and region selected in above drop downs, a list of products should be fetched from the backend and this should be displayed in a new drop down called "Products".


Here I am desriing only 3 drop downs, actually there are more than 10 such drop downs, wherein based on selection of one or more drop downs the values in the next drop down is populated.

The traditional way is using expresssion or query rules but it will adve...

OriginalPostID-235725

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    @komalc - As considering the performance, we can have the all the datasets required for the dropdowns during initial loading by keeping in local variables and based on the each dropdown selection we can take the subset of data from the datasets (local variables). i.e.no need to have do call for each interaction.Here one time data fetching from database.

    Alternatively we can have database call for each selection to get the particular set of data based on selected value.Here for each interaction it will take some time to fetch the data from database.
Reply
  • 0
    Certified Lead Developer
    @komalc - As considering the performance, we can have the all the datasets required for the dropdowns during initial loading by keeping in local variables and based on the each dropdown selection we can take the subset of data from the datasets (local variables). i.e.no need to have do call for each interaction.Here one time data fetching from database.

    Alternatively we can have database call for each selection to get the particular set of data based on selected value.Here for each interaction it will take some time to fetch the data from database.
Children
No Data