项目级别权限和查找列-SharePoint Online. [英] Item Level Permissions and Lookup Columns - SharePoint Online.

问题描述

I'm trying to build a simple Garage Management System to see what spot someone is assigned. So I have the following lists:

车库
级别
景点

Garages
Levels
Spots

Spots对Levels有一个查找列，Levels对Garage有一个查找列.因此，每个地点都有一个指定的车库.

Spots has a lookup column to Levels, Levels has a lookup column to Garages. Therefore, Each spot has a specified Garage.

现在，我被要求为每个车库分配一个车库管理器.那个车库经理应该能够管理关于那个车库的一切，但是不能管理任何其他车库.

Now I have been asked to assign a Garage Manager to each Garage. That Garage manager should be able to manage everything about that Garage, but not any other garage.

将所有列表过滤到特定车库的最简单方法是什么?

What would be the easiest way to filter all the list to a specific garage?

推荐答案

您可以使用这样的计算列

You can use calculated column like this 

https://social.msdn.microsoft.com/Forums/office/zh-CN/641ac447-f616-4e68-ad4f-8715f4b5ca45/filter-the-options-of-a-lookup-column?forum=sharepointdevelopmentprevious

https://social.msdn.microsoft.com/Forums/office/en-US/641ac447-f616-4e68-ad4f-8715f4b5ca45/filter-the-options-of-a-lookup-column?forum=sharepointdevelopmentprevious

您也可以尝试这种方法

https://social.technet.microsoft.com/Forums/lync/zh-CN/31716044-d039-4b72-971e-9d4920bafe3f/connecting-sharepoint-lists-and-item-level-permission?forum=sharepointgeneralprevious

https://social.technet.microsoft.com/Forums/lync/en-US/31716044-d039-4b72-971e-9d4920bafe3f/connecting-sharepoint-lists-and-item-level-permission?forum=sharepointgeneralprevious

这篇关于项目级别权限和查找列-SharePoint Online.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！