SharePoint 2013级联列表帮助 [英] SharePoint 2013 Cascading List Help

问题描述

大家好，

我在SharePoint 2013列表中构建了2个从属下拉列表，但是我需要这2个选择才能在单独的列中吐出与从属下拉选择相关联的课程ID和提供ID.

I have built 2 dependent drop down lists in my SharePoint 2013 list, but I need the 2 selections to then spit out in separate columns a course id and offering id associated with the dependent drop down selection.

例如.

选择资产(取决于下拉列表)

Select Asset (dependent drop down)

选择单位(取决于下拉菜单-取决于所选资产)

Select Unit (dependent drop down - dependent on Asset selected)

课程ID:-自动识别与所选单元相关的课程ID

Course ID: - automatically identifies the course ID associated to the Unit selected

优惠ID:-自动识别与所选单位或课程ID相关的优惠ID

Offering ID:- automatically identifies the offering ID associated to the Unit selected or course ID

我已经搜索了整个Google，但找不到解决方案.我真的是SharePoint 2013的新手，所以到目前为止，我开发的所有内容都是通过反复试验得到的，而Google和Youtube都在帮助我.我追求最简单的 方式(如果可能)

I have searched all over Google and have not been able to find the solution. I'm really new to SharePoint 2013 so everything in terms of what I have developed so far has been through trial and error and Google and Youtube helping me. I'm after the most simple way of doing this (if possible)

非常感谢

TT

推荐答案

TT，

要满足您的要求，我们需要创建两个附加列表并使用SPServices.请参考我的环境中的列表和列名称以及以下步骤:

To achieve your request, we need to create two additional lists and use SPServices. Please refer to the lists and columns name in my environment and the steps below:

1.创建一个列出所有资产名称的列表:

1.Create a list which list all the Asset name:

2.创建一个列出所有单元名称的列表和一个从"list4"中获取信息的查找列，以及CourseID和OfferingID列:

2.Create a list which lists all Unit name and a lookup column which gets information from "list4", and courseID and OfferingID column:

3.在原始列表中打开要获取所有信息的NewForm页面，添加一个Content Editor Web部件.单击功能区中的编辑源代码"，向其添加以下脚本:

3. open NewForm page in the original list which you want to get all the information, add a Content Editor Web Part. Click Edit Source in the ribbon, add the script below to it:

<script src=" https://code.jquery.com/jquery-3.2.1.min.js " type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices-2014.02.min.js"></script>
<script type="text/javascript">

(document).ready(function() {

(document).ready(function () {

().SPServices.SPCascadeDropdowns( { lationshipList:"list3"， lationshipListParentColumn:资产"， lationshipListChildColumn:标题"， parentColumn:查找资产"， childColumn:查找单元"， 调试:true });

().SPServices.SPCascadeDropdowns( { relationshipList:"list3", relationshipListParentColumn: "asset", relationshipListChildColumn: "Title", parentColumn: "lookup Asset", childColumn: "lookup unit", debug: true });

这篇关于SharePoint 2013级联列表帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！