Limiting user's table editing options

Hello,

I’m trying to make only John Smith can edit/delete the record of this company (Apple Inc.), since he is “App Manager”.

In Companies table I set the following formula:
IF([Company App Manager] = LOOKUP(USEREMAIL(), Users, User EMail, User ID), “ALL_CHANGES”, “READ_ONLY”)

When tested, it show that returned value is ALL_CHANGES, but when saving, it gives an error:
Table ‘Companies’ has an invalid update mode expression ‘=IF([Company App Manager] = LOOKUP(USEREMAIL(), Users, User EMail, User ID), “ALL_CHANGES”, “READ_ONLY”)’. Unable to find column ‘Company App Manager’

What is the problem?
Thank you!

Solved Solved
1 5 363
  • UX
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

A tables Are updates allowed? setting applies to the table as a whole, not to individual rows. To control access to individual rows, you’ll need to configure the Only if this condition is true setting for the Add, Delete, and/or Edit system-generated actions as appropriate.

View solution in original post

5 REPLIES 5
Top Labels in this Space