Trying to use USERROLE() and had trouble sync...

[Mike_A]

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.

SWITCH(USERROLE(),

“Admin”, “ALL_CHANGES”,

“READ_ONLY”)