January 25, 200718 yr Newbies New to the forum and I have a question. I am setting up a database, and would like to have a user be able to completely create a new record, but also be able to edit one field in all other records (but only that field, not allowed to edit any other field in records they did not create during their login). I can get each of these things independently, but can't seem to be able to get a user that has both restraints. How do I do this? (If its possible) I tried searching this forum but didn't find it, and the help files don't have it either. Thanks for any help!
January 25, 200718 yr The only way I really know of that you could do this is to create 2 different layouts one with access to all fields and then one with access to only that one field. Whenever they look at the record in the future always send them to the second one. To set your field access on a specific layout, use your privilege sets and also use Control + Alt + K on a field to block entering data in find mode/browse mode. Hope this helps.
January 25, 200718 yr using record level access allow users to edit records they create. Conversely, this means they cannot edit ones they did not create. For those records--the ones created by othe users--have the editing of the single field that you want all users to be able to edit be accomplished by a script set to run with full access privileges. HTH Steven
Create an account or sign in to comment