How to setup Row Level Permission without column Editable If

AppSheet AppSheet Q&A
1

I have a table containing approximately 40 fields. Most users can edit the table but if the status field for the record is “Complete”, I’d like to prevent the ability to edit the row when the role of the logged-in user is Technician (vs. Admin.). I’ve already setup the roles capability etc

Is there a way to configure this permission without having to use the Editable If option for each of the 40 fields?

Thanks everyone

2

In case you didn’t already consider these alternate techniques (which may or may not be compatible with other requirements you have for the app):

  • Create a condition for the table’s Edit action
  • Segregate Technician users’ access to the rows via views associated with distinct slices and make relevant slices read-only
  • Exclude the relevant rows from Technician users via security filter
1 Like
3

(BTW, you inadvertently posted in the Tips forum. I suggested to moderators to move it to Q&A so your question is more likely to be discovered.)