1 of 1 people found this helpful
build a data entry interface ontop of a bunch of globals that has a submit button and at submit click you validate and move the data from the globals to the real records in a table.
Thank you but I actually found an easier way to do it. I just created a script trigger that checks to see if the field is empty which in our case, the field will not be empty unless it is a new record, and if it is empty, exit the script and let all of the users modify the field. However, if it is not empty and they are not logged in the account name of admin, it will display an error message that they do not have access to the field. Thank you all for your help!