Are updates allowed? not working as expected

AppSheet AppSheet Q&A
,
1

Hi All

I get the following error however in expression assistant does not show any issue.

The columns exist and the code is as follows :

IF
   (
    OR
      (
       USERROLE()="Admin",
       ANY(SELECT(SUPERADMIN[DEVICE], ([DEVICE] = CONTEXT(Device))))=TRUE
	  ),
       "ALL_CHANGES",
   IF(
      ANY(SELECT(USERS[MEMROLE], ([MEMDEVICE] = CONTEXT(Device)))) = "GROUPMAN",
      "ADDS_AND_UPDATES",
      "UPDATES_ONLY"
     )
   )

Any ideas ?

Thank you
J

2

Junaid_Hansrod:

I get the following error

What error? Please post a screenshot.