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
Solved! Go to Solution.
Hi,
Thanks for your response.
I did this in the auto compute/suggested value :
select(table_ref[Key],in([Code],[_THISROW].[Code]))
If I see it, You can try this formula at Valid if:
SELECT(table_Ref[Value_Enum_column],[_THISROW].[Code] = [Code])
Hi,
Thanks for your response.
I did this in the auto compute/suggested value :
select(table_ref[Key],in([Code],[_THISROW].[Code]))
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |