Good day, how can i achieve filtering the ref...

AppSheet AppSheet Q&A
1

Good day, how can i achieve filtering the ref column in other forms that it is used?

2

@Jessrhyl_Longay

In your ref column’s Valid_if you can use a SELECT expression:

SELECT(TableName[KeyColumnName],NOT(IN([LookupColumn],TableName[KeyColumnName])))

3

And in generally… SELECT(TableName[KeyColumnName],YourOwnEvaluation)

4

@Levent_KULACOGLU this was what i did. thanks