What is the best way to disable edits to system-maintained fields?

renna808
Tera Contributor

I've noticed in our instance that the previous developers have added the following fields to several of our record layout pages.   The problem is that these fields are editable by the user and I'd like to like to lock them down.   I would even want to prevent users with the "admin" role from modifying these values.

  • sys_created_on
  • sys_created_by
  • sys_updated_on
  • sys_updated_by

My initial thoughts were to create an ACL for each of the fields above and have the script just return a false value.   But that seems like a lot of work to do on each and every table where these fields have been added to the form.   Is there an easier way to accomplish this?

1 ACCEPTED SOLUTION

Jim Coyne
Kilo Patron

The ACL route would be the best way.   And to make it real easy, you can use *.sys_created_on for it to apply to that column name on all tables.   And as a matter of fact, there are probably a number of OOB ones that are just inactive, so you can turn them on.   Uncheck the "Admin overrides" field so admins cannot modify the fields either.


View solution in original post

3 REPLIES 3

Jim Coyne
Kilo Patron

The ACL route would be the best way.   And to make it real easy, you can use *.sys_created_on for it to apply to that column name on all tables.   And as a matter of fact, there are probably a number of OOB ones that are just inactive, so you can turn them on.   Uncheck the "Admin overrides" field so admins cannot modify the fields either.


Thanks Jim for the solution!   It works perfectly and it was easy to implement.   Thank you for saving me hours worth of work!


You are welcome!