Data Slices Improve Sync Time

[tvinci]

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"

[Steve]

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.