I’m using the following as an Are Updates Allowed? rule:
IF(
OR(
IN("Manager",INDEX(CURRENT_User[Type],1)),
IN("Admin",INDEX(CURRENT_User[Type],1))
),"ADDS_AND_UPDATES",
IF(
ISBLANK(UserEmail()),"ALL_CHANGES",
"READ_ONLY"
))
but when I try to edit a record I get:
Table 'Plot' does not allow this operation. Expression result:
'READ_ONLY'.
Expression Trace:
{"key": "IF(OR(IN(\"Manager\",INDEX(CURRENT_User[Type],1)), IN(\"Admin\",INDEX(CURRENT_User[Type],1))),\"ADDS_AND_UPDATES\",IF(ISBLANK(USEREMAIL()),\"ALL_CHANGES\",\"READ_ONLY\"))","result": "READ_ONLY","values": []}
CURRENT_User is simply a slice to not have to use ANY(Select(… multiple times
I’ve tested the formula in UserSettings and as a whole I get a result of “ADDS_AND_UPDATES” and INDEX(CURRENT_User[Type],1)) gives me “Admin”.
So I’m a bit stuck as to how its clearly getting “READ_ONLY” at the table level
Solved! Go to Solution.
CONCATENATE()
should help
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |