Switch of roles not working

[vicoor]

Hi everyone!

I have a problem in my switch.

I try to distinguish among some roles: admin, inspect, technician, employee:

admin: ALL_CHANGES
inspect: ALL_CHANGES
employee: READ_ONLY
technician: ADDS_AND_UPDATES

Show More

The app distinguishes among the roles well. And it is shown with buttons with different actions depending on whether the user can add, edit or delete.

Ok, that's perfect, but the problem is that when an admin or inspect try: add, edit or delete the app fails. For example, when I add a register with a admin user:

I waited a minute but not working, so I push on this button, and:

Unable to add row to table 'Residuos'. → Table 'Residuos' does not allow this operation. Expression result: 'READ_ONLY'. Expression Trace: {"key": "SWITCH(ANY(SELECT(Usuarios[role],([EMAIL] = USEREMAIL()))),\"administrador\",\"ALL_CHANGES\",\"inspector\",\"ALL_CHANGES\",\"empleado\",\"READ_ONLY\",\"tecnico\",\"ADDS_AND_UPDATES\",\"READ_ONLY\")","result": "READ_ONLY","values": []}

I think that my switch is ok, but i don't know why the app fails to add a register with admin

Thanks!

[jaichith · Accepted solution]

please follow this thred.

 https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/DYNAMIC-USER-CONTROLS-EDIT-NO-ACCESS-ETC/td-p/5...

it is so simple. 

[jaichith · Accepted solution]

When you have table like what I have done, you can change the user access based on access what you give.  secondly all those access can be edit or changed in the app interface. you need not change in table properties like switch(). 

It is kind of dynamic user controls. all amendments I do in app itself. I will not change in properties.