valid if

[Jpoza]

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.

[Marc_Dillon]

https://help.appsheet.com/en/articles/961426-references-between-tables

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

[Aurelien]

Just set the Name column in your table Clock In, with type Ref, source table Employee List.

[Jpoza]

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 

[Marc_Dillon · Accepted 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] )
)

[Jpoza]

Love you bro Marrc_Dillon. Thank you so so so much.
I am so happy thank you again bro, I appreciate your time.

[Steve]

@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))))

[lizlynch]

Hi,

Thank you @Steve and @Marc_Dillon for helping to resolve this issue.

As suggested, I made the following doc updates:

• Check form input validity (Valid_If) - Added the examples recommended above.
• Drop-down from Valid_If - Added the tip: To check form input validity without creating a drop-down, see Check form input validity (Valid_If).

Appreciate this community! 

Liz