Modify Permissions

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
HI there,
I have a form that I'd like a specific group of users to be able to fill out, meaning add a record, and after saving the record, only be able to modify one field, in this case, confirm services. Is there a way to restrict access to all other fields when modifying the record?
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
If you make a field called [Record ID# mirror] with a formula of [Record ID#] you can use that in a form rule.

When [Record ID# mirror] > 0
make read only ..
this field
that field
that other field.

The [Record ID# mirror] will be greater than zero when the record already exists, so it will be blank when the record has not yet been initailly saved.

For some reason you cannot use the [Record ID#] field in form rules - not sure why, so the mirror field is a cheat to get around that arbitrary limitation..
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
I think I understand....I'll give it a shot and let you know if I need any more help. Thanks a million!