Multiple Dependent Dropdown

ekoy
New Member

Here is the preview of the app

If the users select Money In, I only want Dr. to appear in the app not both, Dr and Cr.

What expressions do I need to use or formula if any?

Thank you.

Solved Solved
0 2 158
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

Hi @ekoy

I donโ€™t think your question is about dependent dropdown, itโ€™s rather a dependent show/hide.

I suggest you have a look to the AppSheet documentation provided.
The first result I get at typing โ€œhideโ€ is the answer to your question:

To do so:
You need to click on the black pen attached to the field you want to show/hide
3X_5_c_5cb2af8c6feb90841b226fcfcbfae7bc9de3780c.png
Then, click on the expression icon:
3X_4_b_4b2d575e12ed7fd52cf5935effe3768b1cdaf4d5.png
Then, type your Yes/No expression. For example:
[Inflow/Outflow]="Money In"
or
[Inflow/Outflow]="Money Out"

Let us know if that works for you !

View solution in original post

2 REPLIES 2

Aurelien
Google Developer Expert
Google Developer Expert

Hi @ekoy

I donโ€™t think your question is about dependent dropdown, itโ€™s rather a dependent show/hide.

I suggest you have a look to the AppSheet documentation provided.
The first result I get at typing โ€œhideโ€ is the answer to your question:

To do so:
You need to click on the black pen attached to the field you want to show/hide
3X_5_c_5cb2af8c6feb90841b226fcfcbfae7bc9de3780c.png
Then, click on the expression icon:
3X_4_b_4b2d575e12ed7fd52cf5935effe3768b1cdaf4d5.png
Then, type your Yes/No expression. For example:
[Inflow/Outflow]="Money In"
or
[Inflow/Outflow]="Money Out"

Let us know if that works for you !

Hi @Aurelien

I already solved my problem through your recommendation. I really appreciate your response. Until next time.

Have a good day ahead.

Top Labels in this Space