I have a TableA that already has a security filter for ColumnX = “Something”. Now I would also like a security filter in TableB where the relationship between TableB and TableA is stored in TableC in Columns TableB_key and TableA_key.
In a SQL like query this would look like:
Select * from TableB Where TableB.key = TableC.TableB_key And TableA.key = TableC.TableA_key And TableA.ColumnX = “Something”
Due to restrictions of comparing values to lists ultimately I tried this in AppSheet but did not get any results:
AND(IN([key], TableC[TableB_key]), IN(TableA[key], TableC[TableA_key]), IN(“Something”, TableA[ColumnX]))
Is something like this even possible in AppSheet and if so does anyone have any suggestions? The main reason I am using this approach is because I want to keep the amount of data returned to the app more manageable.