Our database is set up so that users in certain roles are prevented from editing records when those records meet a certain criteria (i.e., IS_LOCKED = True). This locks every field in the record, which is fine for the most part, except that there are times when we want to allow the user to still make some changes but only to certain fields.
For instance, even though a record is locked, it may still need to be approved for processing by another department. The approval process is automated through the use of an "Approve" button which edits the record and adds the approver's name and the current date.
When the record is locked as indicated above, however, the button throws an "Insufficient permissions" error.
So the question is, Is there a way to bypass the role permissions to allow the "Approve" button to work even when the record is locked?
Thanks in advance.