Using related list to hold restricted fields

Peter Blankenheim 1 Reputation point
2020-08-21T21:15:40.063+00:00

SharePoint doesn't do user restrictions at the field level, so I am wondering about a workaround. I have a calendar (event list) for reservation requests, and I would like to have a separate list, "approvals" that has restricted access where the request approvals are made. What is the best way to get the "Approved" field from the restricted list to show up in the calendar? I tried just putting the whole 'approvals' list on the calendar's edit form webpart, as an added webpart. It worked but not very helpful. I would like to make it so only certain people can change an approval (so have the 'approvals' list restricted). Then I'd like a native field in the calendar to read (import) the value from the approvals list. This would be easier with InfoPath, but the Sups want to avoid using that on this project. Does anyone have an idea of what I should be investigating?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Itch Sun-MSFT 2,556 Reputation points
    2020-08-24T07:57:40.177+00:00

    Unfortunately, this needs is still unable to be achieved.

    No matter what permission settings you've made for this field before, once you've done this step:

    Then I'd like a native field in the calendar to read (import) the value from the approvals list.

    We still have no control over who modifies it in the calendar list.

    As you know, SharePoint doesn't do user restrictions at the field level, if you're good at code, maybe you can try the methods mentioned in the following article:

    Field level permission development

    Please note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

    In addition, I suggest you vote and monitor the issue in user voice, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

    Support Field level Permissions

    If the response is helpful, please click "Accept Answer" and upvote it.

    Thank you for your understanding.

    0 comments No comments