DROPDOWN values

Hi Bubblers !
While transferring a PARAMETER through Page URL, the ‘display data in a group’ expression is being used to show details of a PROPERTY (this is the THING). This GROUP contains few DROPDOWNS whose value was DYNAMICALLY populated using OPTION SETS. Now, since the values of this GROUP are being fetched from the DB, how to show the values of the DROPDOWNS ?

Screenshots for reference :
1 EDIT Icon navigates to PROPERTY_PAGE
2 PROPERTY details being sent to PROPERTY_PAGE
3 GROUP on PROPERTY_PAGE
4 DROPDOWN Property Type not accepting value from DB
5 DROPDOWN City not accepting value from DB





You probably don’t use the same type in DB field VS Dropdown Settings.
For example: You have set the dropdown to an option set or DB type while the field property_type is a text.

hi @Jici , Thanks for your revert.

Yes, the settings are different as you mentioned. Is it possible to show the same option that was originally selected from the OPTION SET ? Please advise.

You need to use filter (Get all option:filtered) or change dropdown type to text
Honestly, you should change your DB field to the OS type instead.

hi @Jici , thanks for your revert. Sorry for late response.

This Dropdown (City) is dependent on Another Dropdown (State). So, although the State’s value (State Db field is Text Type) is getting displayed, applying ‘:Filtered’ doesnt seem to work to get the City’s value ? Please advise.


Filter Setting - not getting accepted

Now, since the Field Type is Text, can you please advise how to proceed to changing it to OS Type. Even if we create a new Field, then how to get City data of existing Properties into that New Field of type OS ?

probably you need to complete with display.
In most case your filter should like display = Item city field (text):first item,s display
Can you share dropdown settings (Appearance tab)

As per your advise, I applied ‘:Filter’ multiple times, & hence was able to get the required output.
1st FILTER : to get City OS with matching State, as in DB
2nd FILTER : to get City OS with matching City, as in DB

Here are the DROPDOWN Settings (Appearance Tab), for reference

Thank you for your help ! :heart:

This topic was automatically closed after 70 days. New replies are no longer allowed.