使用Infopath自定义SharePoint-隐藏下拉菜单(如果已选择) [英] Customizing SharePoint using Infopath - Hidden Dropdown Choices if already taken

问题描述

我需要有关Infopath选择的帮助.

我正在尝试创建一个下拉列表，其中已采取的选择不会显示在列表中.

例如:

我有一个列表A，选择的数字是1-50.

我想要实现的是，如果已经使用数字 14 ，它将不会显示在列表A中.

希望您能在此方面为我提供帮助.

解决方案

凯文·克拉克·巴拉鲁，

我们可以使用工作流程和InfoPath来实现.创建另一个列表来存储数字(1-50).在listA中选择数字后，运行 将listB中的数字设为选定"的工作流程.在列表A表单中，过滤未选定"的数字.

步骤如下:

1.创建一个名为"listB"的列表以存储这些选择数量.创建一个名为"selected?"的列用来检查是否选择了该号码.

2.在listA中，创建一个查找列以从LIstB获取信息.

3.在listA中，使用SharePoint Designer创建工作流，并在创建项目时自动启动它.在此工作流程中，更新已选择?"栏位值 相对listB项.

注意:默认情况下，查找列的值是物品.因此，我根据ID找到了商品.检查您的查询值类型.

4.使用InfoPath自定义listA表单.

5.将数据连接添加到listB并确保已选中?"字段被选中.

6.过滤查找下拉列表值.条件:已选择?"字段不等于已选择".确保查找值是ID，因为我们在中找到了基于ID的项目 第3步.

7.发布表单.所选值将被隐藏.

最好的问候，

Linda Zhang

Hi guys,

I need help regarding Infopath choices.

I'm trying to create a list of dropdowns wherein choices that are already taken won't show up in the list.

For example:

I have a list A and choices are numbers from 1 - 50.

What I want to achieve is that if the number 14 is already taken, it won't show up in list A.

I hope you can assist me with this. Let me know if you guys need clarifications.

解决方案

Hi Kevin Clark Balauro,

We can use the workflow and InfoPath to achieve that. Create another list to store numbers (1-50). When the number is selected in listA, run a workflow to make the number in listB as "selected". In list A form, filter the numbers which are not "selected".

Here are the steps:

1. Create a list named "listB" to store these numbers of choices. Create a column named "selected?" which is used to check whether the number is selected or not.

2. In listA, create a lookup column to get information from LIstB.

3. In listA, create a workflow using SharePoint Designer and automatically start it when an item is created. In this workflow, update the "selected?" field value for the relative listB item.

Note: By, default, the lookup column value is the ID of the item. So, I find the item based on the ID. Check your lookup value type.

4. Customize the listA form using InfoPath.

5. Add a data connection to listB and ensure the "selected?" field is selected.

6. Filter the lookup drop down values. Condition: "selected?" field is not equal "selected". Ensure the lookup value is ID since we find the item based on ID in step 3.

7. Publish the form. The selected values will be hidden.

Best Regards,

Linda Zhang

这篇关于使用Infopath自定义SharePoint-隐藏下拉菜单(如果已选择)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！