Forum Discussion

Jay_DDS_'s avatar
Jay_DDS_
Qrew Cadet
9 years ago

Modify Permissions

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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    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..
  • Jay_DDS_'s avatar
    Jay_DDS_
    Qrew Cadet
    9 years ago
    I think I understand....I'll give it a shot and let you know if I need any more help. Thanks a million!