Hello AppSheet,
I have a Users table with the names of all my users and their respective roles, either “Dispatch” or “Driver.” I used this lookup expression to make a certain visible to only Dispatch and it worked, but it didn’t work for Drivers. What did I do wrong?
Thanks.
lookup(
useremail()
,"users"
,"id"
,"role"
)="Dispatch"
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |