Posts

Limit users to their own data

Limit users to their own data When you use security filters, you typically: Require user sign-in . After a user signs in, AppSheet knows the user's email address. You can then use the user's email address to filter the data shown to that user. Include a field in each record that identifies the owner of the record. Typically this field contains the owner's email address. When adding a new record to a table, you can use the  USEREMAIL()  function in that field's Initial Value property to initialize it with the user's email address. Security filters are optional  Yes/No  expressions associated with each table in the app. They typically use the user's email address, and possibly other data values, to limit the data shown to the app user.  To limit access by user email: [EmailColumn] = USEREMAIL() To limit access by user email domain: CONTAINS(USEREMAIL(), [EmailDomainColumn]) To limit access by user email but allow any manager to have access, create a  Managers...