Valid_If ??? Before a user can fill in a for...

[Jim_Davidson]

Valid_If ???

Before a user can fill in a form, I want to check that the user is part of the team. Example: My form has EmployeeID a required field. I have a separate table for employee’s. Can I use valid_if to check that the employeeID is in the employee’s list?

If not, the user will not be able to proceed filling out the form.

Will it work this way? If so what would the formula look like - if not how would I go about doing this check please? Thanks JIM

[Levent_KULACOGL]

@Jim_Davidson you can check it of course

IN([EMAIL], EMPLOYEE[USEREMAIL])

expression will work for that…

[Jim_Davidson]

Thank you - however as soon as I try and use this formula it created a dropdown list that I don’t want. =IN([Employee], Drivers[Employee])

[Aleksi_Alkio]

Easiest way is to write the expression directly into table access.

If he’s not part of that group, you can give only read_only access.

[pravse]

Did you want the person to type in the id and then verify it?

In most cases, the goal of valid_if is not for authorization/security but for data validity. So it tries to help the user submit a valid entry.

Aleksi’s suggestion is best if your goal is to control access