Trying to use USERROLE() and had trouble sync’g changes made on mobile app.
If I add USERROLE() (see below) to the “Are updates allowed?” section of the table properties, it is wonderful because non-admin users cannot edit records for specific tables, without having to specify each email address.
This is great!
BUT, if I then try to add a record using my iPhone (signed in as Admin), I can edit the record, but the sync fails with an error of "Table ‘xyz’ does not allow this operation.
I then actually have to delete the iPhone app to kill the cache records and re-install or syncs will never work.
Everything works great if I set the “Are updates allowed?” using the green buttons, but not if I add the Switch statement below in the expression assistant.
Any ideas how to solve?
ps: in case it matters, the source is a google sheet in
a business environment.