Hi all, Is it possible to restrict the dropdown lists within a form based on other selections?
For example, if there are 3 tables where table 2 has a ref column to table 1. Table 3 then has a ref to table 1 and 2, so that in the input form for table 3, there is a dropdown selection for the ref to table 1, then based on that selection, the dropdown list for the ref to table 2 is restricted.
Iโve tried a few things but canโt get this to work. Is this possible?
SELECT(Tbl2[KeyCol], [Tbl2To1Ref]=_[_THISROW].[Tbl3To1Ref])
Please see the help document on dependent dropdowns.
help.appsheet.com - AppSheet Help Center
and then search for โdependent dropdownโ AppSheet Help Center help.appsheet.com
@Bellave_Jayaram Thank you, this worked.
@praveen, I did read this help document but unfortunately it didnโt work for this app because this solution only works for situations where the information comes from a single table not multiple tables as in my case. Thanks anyway though.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |