Dependent dropdowns question

[oddswere]

I have an application where I need to select an item in a three-level list. That is, one column is the top level and others are formed relative to it. But if you select the lower level, then the upper ones should automatically become relative to the lower level. Initial value does not work well, for example, when I already select something in this column, then when I select something in lower level, nothing happens there. Is it possible to solve this problem somehow?

[Aurelien]

Hi @oddswere

Welcome to the community !

This question has been asked multiple times in the community, you may find an answer among the results here:
https://community.appsheet.com/search?q=dependent%20dropdown

Plus, I suggest you have a look to this post, as it has good advices in it

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

Let us know if you don’t succeed into it !

[oddswere]

I want to find a way to make a field work like an app formula, but at the same time it could be changed depending on other fields because initial value is not suitable

[Aurelien]

Hi @oddswere

That’s different from your initial question, then.

You may want to use a “pick first choice” column, then “correct if not suitable” column, with its initial value set to “first choice” column.

Please have in mind that:

• initial value expression behave as app formula expression, until the user change it manually
• you may have to use a workaround as described above for you case

Also, with that:

oddswere:

but at the same time it could be changed depending on other fields because initial value is not suitable

we don’t have enough context for giving you some help. You may want to provide further informations.