Need Expression to create a list of city based on the "State Name" Selected in above column

[Gagan_Arora]

want to create a drop down list of cities based on the state name selection made in above column

Kindly help

[Steve]

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.

[Gagan_Arora]

Thank you Steve for your reference link. But what if i dont have any reference table to source the list options from.

Can i create a list of city names within the same table using any expression?

[Steve]

So you need a list of city names? You would need to provide that yourself; AppSheet doesn’t provide the data. Or maybe I don’t understand what you’re telling me?

[Gagan_Arora]

like in enum expression we can create a list of values to choose from, in the same way can we create a drop down list values with expression which is dependent on another column values?

in the reference video you shared to understand dependent drop down, he was using a different table for reference to choose the values he wants to show in his current selection

[Steve]

Perhaps this?

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

[Gagan_Arora]

I have created a dependent drop down using a reference table successfuly. But for this i had to add a new reference table. Which is now showing in UX. I dont want to make it visible for users. How can i do that?

[Steve]

Can you clarify what you mean by “showing in the UX”? Screenshot?

[Gagan_Arora]

I dont want to make it visible to any one except admin

[Steve]

Delete the view in UX >> Views.

[Gagan_Arora]

Done Thanks!