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

Question

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.

mcfneil · Answer

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)

quickbasecoachd · Answer

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 · Answer

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 · Answer

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.

Forum Discussion

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

Related Content

Many parent records on a single child record

Field to "assign" a user group

Modify multiple rows within the same group using Single Record ?

Copy Single Table from One App to Another

Can I create a single field that displays record owners from a child table