filter a view on table 2 based on a EnumList column from table 1

AppSheet AppSheet Q&A
, ,
1

Hello!

I tried to use Linktofilteredview function in an Action in order to send the user when he saves the form on Table 1 to another view on a slice of Table 2, it is important the second view to be filtered depending on the 1 to many ID selected in a EnumList column. The unique ID from Table 2 is the same with the ID found in the EnumList column from the Table 1.

I tried using IN() inside Linktofilteredview, even IN(IN() …), but it is not ok, the result is nothing, even the formula seems to be correct (it is green).

Could anyone give me an idea how should I write this expression?

Thank you very much!

Regards!

Ruxandra

2

Was your LINKTOFILTEREDVIEW() condition like the following:

LINKTOFILTEREDVIEW(“Table2”, IN([Unique ID],[_thisRow].[EnumList Column]))

3

Hello!

I’m sorry, I think I didn’t explain well: in Table 1, the enumlist column has a name like IDTable1, and the Table2 has a column named IDTable2 which is type “Text” and it is “UniqueID”; in the IDTable1 column from Table1 I display the list of the column IDTable2 (based on certain condition), and user can check one or many data.

If I use your formula, I receive error it can’t find the column IDTable2.

Thank you for your help!

Regards!

Ruxandra