Forum Discussion

SarahSarah's avatar
SarahSarah
Qrew Cadet
8 years ago

Can I assign field permissions to a single user vs. role?

Can I create a field and restrict the edit properties by user instead of by role? I have a meetings table and, in the table, each user has their own designated text box where they add info they want t...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Sarah,
Really, a better approach is to have a child table to your meetings.

So one meeting has many meeting comments.

Then you can totally control of the permissions on that child meeting comments table.

For example perhaps users can only create and edit their own records but view all records?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    I was assuming that was already done.

    But using the checkbox, you wouldn't have to modify all the roles that exist, or keep an eye on it every time you add a new role.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    The other super low tech solution is to simply change the text box to one which logs changes.

    There is a field property checkbox for that on all text field.

    That way everybody can make their comments and it will be automatically date and user stampeas to who made the comment. The only disadvantage is that if the user makes a spelling mistake or typo then they will not be able to correct their data entry.