Hi guy's
I need valid if expectation for the form "name" column, For validate same name as in my database Employee List Table>Name column.
The Form should be saved when the user enters a wrong name.
Solved! Go to Solution.
To disable the automatic dropdown, but keep the validation checking against a List, nest an IN() expression within an OR( false , ... ) or AND( true ,... )
OR(
FALSE ,
IN( [_THIS] , table[column] )
)
Just set the Name column in your table Clock In, with type Ref, source table Employee List.
Thank you for your reply but friends I don't wont to show all employee name to every users...I need to do is Users fill a name correctly {IN130 Jignesh} mins { Storecode then space then name }
Is any other way ? to do that
To disable the automatic dropdown, but keep the validation checking against a List, nest an IN() expression within an OR( false , ... ) or AND( true ,... )
OR(
FALSE ,
IN( [_THIS] , table[column] )
)
Love you bro Marrc_Dillon. Thank you so so so much.
I am so happy thank you again bro, I appreciate your time.
@lizlynch Please add to Drop-down from Valid_If - AppSheet Help:
In some cases, you may not want the dropdown behavior from Valid_If. To avoid it, wrap the list expression like this:
AND(TRUE, IN([_THIS], list-expression))
For example:
AND(TRUE, IN([_THIS], LookupTable[ColumnC]))
Or:
AND(TRUE, IN([_THIS], SELECT(LookupTable[ColumnC], ([ReportDate] > (TODAY() - 7))))
Hi,
Thank you @Steve and @Marc_Dillon for helping to resolve this issue.
Appreciate this community!
Liz
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |