I have a pretty simple question but am having...

ux
(Phil Renda) #1

I have a pretty simple question but am having difficulty finding the answer. How can I filter the dropdown list on a form entry based on another column?

For example, if I have a form that has Region and State, when I select the Region, the State field will prepopulate a smaller list to choose from.

I know this is probably simple and I am overlooking the solution; thanks in advance for the help.

(Suvrutt Gurjar) #2

Hi Phil,

Please see if concept of dependent drop down helps you

help.appsheet.com - Dependent Dropdown Dependent Dropdown help.appsheet.com

(Suvrutt Gurjar) #3

This sample app will also be useful reference

appsheet.com - Dependent Dropdowns - How to create a dropdown menu with values that depend on earlier choices Dependent Dropdowns - How to create a dropdown menu with values that depend on earlier choices appsheet.com

(Praveen Seshadri (AppSheet)) #4

Thanks for your help @Suvrutt_Gurjar

(Suvrutt Gurjar) #5

Hi @praveen , thank you very much for your note. It is really a great feeling to be a tiny part of this awesome Appsheet community.

(Phil Renda) #6

Thanks for the help @Suvrutt_Gurjar!

(Phil Renda) #7

This seemed to create the correct dropdown but I am unable to add a new record outside of the pre-populated list.

Any ideas? @Suvrutt_Gurjar

(Phil Renda) #8

@praveen

Do you know if there’s a way to have a filtered drop down list where you can add new records? It seems that this method forces a constraint