Hi Community,
I’ve set a valid if formula in my form to choose a value of Employee name from the Employee table.
Now, I would like to add “N/A” to the list of employees, without adding “N/A” as an Employee name.
How can I also add “N/A” as a choice?
regards
Solved! Go to Solution.
OK I’ve found the solution.
Here the my formula I used as a Valid if constraint
LIST(“N/A”)+sort(select(dbo.Employee[Name],[active]=“Y”))
OK I’ve found the solution.
Here the my formula I used as a Valid if constraint
LIST(“N/A”)+sort(select(dbo.Employee[Name],[active]=“Y”))
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |