Filter on enum column with ref value

AppSheet AppSheet Q&A
, ,
1

Hello,

I have a “valid if” condition on an enum column :

[Column Test]=Lookup([_THISROW].[Column Ref],“Table Test”,“Column Ref Table Test”,“Column Test table Ref”)

Rather than doing a “valid if”, when i add a new row, I would like to display only eligible values ​​in the enum column on my view to add.

How can i do that ?

Thanks

2

If I see it, You can try this formula at Valid if:

SELECT(table_Ref[Value_Enum_column],[_THISROW].[Code] = [Code])

1 Like
3

Hi,

Thanks for your response.

I did this in the auto compute/suggested value :

select(table_ref[Key],in([Code],[_THISROW].[Code]))