@Adam Krzyzanek I believe, but not entirely sure, it may be possible to lock this down via Custom Data Rules. (Located under Advanced Settings in any table, at the bottom)
Add a field (Field name - Current User, field type - Formula Text) that pulls users and ties them to their role, and returns the role value. (i.e. Admin, Tier 1, Tier 2)
Case(true,
User() = "Bob", "admin",
User() = "Steve", "Tier 1",
"")
Then add the custom data rule code, something like:
if([Edit Status] = "Locked" and [Current User] <> "Admin", "Sorry but you may not edit this record. Please speak with a supervisor")
Please note I have not tested this yet, but this is something i have been wanting to do and will probably be trying to do here soon. I will post an update once i have confirmed or determined its not possible. Hopefully this helps some one and maybe they can flesh the idea out before i get around to it.
------------------------------
Dillion Moore
------------------------------
Original Message:
Sent: 03-04-2020 07:59
From: Adam Krzyzanek
Subject: Lock record from edits after a certain condition is met
Is there a way to do similar in Grid Edit?
When Lock MD = Yes than you cannot Edit other Field anymore?
------------------------------
Adam Krzyzanek
Original Message:
Sent: 02-18-2019 05:53
From: Archive User
Subject: Lock record from edits after a certain condition is met
This works well. Thank you!
Regards,
Samuel