问题描述
我创建了一个自定义日历列表来添加活动。
I created a custom calendar list to add events.
我在事件表单中创建/添加'团队'，'团队成员'和'席位号'以应用于特定日期。 ;我在创建验证公式方面遇到了什么困难，以确保
'席位号'未添加到同一日期。 我试过
Enforce Unique Values 但我不允许我使用相同的
'座位编号'会在可用的其他日期。 任何帮助将不胜感激。
I created/added 'Team', 'Team Member' and 'Seat No.' in event form to be applied to specific date(s). What I'm having difficulties in creating a validation formula to ensure that a'Seat No.' doesn't get added to the same date. I tried Enforce Unique Values but I wouldn't allow me to use the same'Seat No.' on a different day when it would available. Any help would be greatly appreciated.
奥兰多
推荐答案
为了确保基于列表中两列的唯一性，有两种方法。
To make sure the uniqueness based on two columns in the list, there are two methods.
1。在InfoPath设计器中自定义表单并创建规则以避免基于InfoPath表单中的两列的重复项目。
1. Customize the form in the InfoPath designer and create rules to avoid duplicated items based on two columns in the InfoPath form.
2。在表单中添加JavaScript代码以满足您的要求。
2. Add the JavaScript code in the form to achieve your requirement.
有关更多详细信息，请参阅以下文章。
For more detailed information, refer to the articles below.
防止重复条目在SharePoint列表中的两列或多列上。
Prevention of duplicate entries based on two or more columns in a SharePoint list.
https://salnikan.wordpress.com/2011/07/26/prevention-of-duplicate-entries-based-on-两个或多个列在共享点列表/
基于Sharepoint列表中多个列的唯一条目。
Unique Entries Based on Multiple Columns in Sharepoint List.
祝你好运，
Sara Fan
这篇关于验证 - 自定义日历列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！