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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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 to discuss in the meeting. I know how to change field permissions by role, but, instead, I want to change the permission by assigning it to one user. I have several users in the same role so essentially they'll all have access unless I can assign to designated users. Please advise.
Photo of Sarah

Sarah

  • 20 Points

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
How do you identify which user can edit it?  Do you have a relationship that contains or uses a "user" field?

If so you can make  formula checkbox to control the logic of who can access it.  Or do it directly in the form rule.

The formula logic would be;

If([User Assigned]=User(), true, false)

Then you shouldn't have to restrict the access by roles, but it will be users (always)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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?
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.