I need "Field X" to be auto populated if you are User Y (standard user), but editable if you are User Z (admin user), basically. I'm not sure if this is possible though.
I asked a similar question here and have adapted some of this for my current app: https://quickbase-community.intuit.com/questions/1305798-is-it-possible-to-automatically-populate-a-...
I have had problems with the auto-populated field because "Field X" needs to be locked down so that "User Y" can't see it or edit it, but allow it to be editable by "User Z", the admins.
For doing a bulk upload via a spreadsheet, the way I have it set right now is linked to the user's email address and who has uploaded the record.. that works for all the "User Y" users as it auto populates the field with the company they work for... but I would like to enable the admins the ability to edit this particular field so it's not auto-populated for them as they may need to perform a bulk upload on behalf of "User Y" and I want them to be able to populate "Field X" with the correct value.
Currently, if I change the formula that auto populates this field, it changes the value for "Field X" for every record that was added by that particular user - which is not what I want.
Hopefully that makes sense.
EDIT: Actually, I think I may have gotten this after looking at another answer referring to a field override.
I've used the below to accommodate this by making [Company Override] and making it only visible to admins, which allows an admin to make a free text change to that field which will pop into the formula field if their name/email address isn't in the below list.
If ([User who uploaded]=ToUser("firstname.lastname@example.org"), "Company 1",
If ([User who uploaded]=ToUser("email@example.com"), "Company 2",
If ([User who uploaded]=ToUser("firstname.lastname@example.org"), "Company 3", [Company Override])))