Issue with User Filtering Based on usermail in AppSheet

Hello,

I'm facing an issue where my AppSheet app isn't properly filtering data for individual users based on their email addresses. Here’s the setup and problem:

  • I have a column staff_id in my table, which contains the email addresses of users.
  • I'm using the USEREMAIL() function in my app to filter data so that each user only sees the rows that they’ve input.
  • However, the filter doesn’t seem to work as expected. Despite having set up the staff_id column to match USEREMAIL(), it either shows all rows or incorrectly filters the data.

Here’s what I’ve tried so far:

  • I’ve created a Slice with a filter condition like [staff_id] = USEREMAIL() to limit data for each user.
  • I've set up the correct user permissions and the app is deployed.
  • I’ve confirmed that users are logging in with different emails (using different browser profiles or incognito).

Despite this, I’m still seeing data from other users or incorrect user data. Is there something I might be missing or a setting that needs to be enabled for proper filtering?

I am using the AppSheet Starter plan.

Any help would be greatly appreciated!

Thank you!

0 1 77
1 REPLY 1

If your data is sensitive, you should use Security Filter instead of a slice. The Security Filter is used in AppSheet server side, not in the device so that data is filtered before the data is pushed to your device.

Top Labels in this Space