Discussions

Expand all | Collapse all

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

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

    Posted 08-24-2017 20:51
    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.


  • 2.  RE: Can I assign field permissions to a single user vs. role?

    Posted 08-24-2017 20:58
    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)


  • 3.  RE: Can I assign field permissions to a single user vs. role?

    Posted 08-24-2017 21:46
    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?


  • 4.  RE: Can I assign field permissions to a single user vs. role?

    Posted 08-24-2017 21:47
    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.


  • 5.  RE: Can I assign field permissions to a single user vs. role?

    Posted 08-24-2017 22:04
    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.