Hi all, Is it possible to restrict the dropdo...

(Carl Foster) #1

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?

(Bellave Jayaram) #2

SELECT(Tbl2[KeyCol], [Tbl2To1Ref]=_[_THISROW].[Tbl3To1Ref])

(Praveen Seshadri (AppSheet)) #3

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

(Carl Foster) #4

@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.