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"
The expression looks okay to me, though I recommend putting the raw value to the left of the is-equal operator (=
) rather than on the right. Though unlikely, the position could cause problems.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |