Skip to main content
Question

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

  • August 25, 2017
  • 0 replies
  • 34 views
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.
    This topic has been closed for replies.

    • MCFNeil
    • Registered
    • August 25, 2017
    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)
    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?
    Terms & ConditionsAccessibility statement