SharePoint 托管应用程序 - 在托管的 Web 列表上创建级联下拉列表

Question

我已经创建了一个SharePoint Hosted App(Javascript Object Model)，它可以在宿主网站上创建列表。

我需要在新建和编辑表单中插入一些javascript代码，以实现两个查找字段的级联下拉效果。

以下是我如何创建此列表及其字段的代码：

    // Create a new list on host web
    var createList = function (listTitle, onSuccess, onFieldsReady) {
    var listCreationInfo = new SP.ListCreationInformation();
    listCreationInfo.set_title(listTitle);
    listCreationInfo.set_templateType(SP.ListTemplateType.genericList);

    var lists = hostWeb.get_lists();
    var newList = lists.add(listCreationInfo);

    currentContext.load(newList);
    currentContext.executeQueryAsync(onSuccess(newList, onFieldsReady), onListCreationFail);
}

    // Create a new field on a list
    var createField = function (list, fieldType, fieldName, fieldDisplayName, fieldRequired, onSuccess) {
    var fields = list.get_fields();
    var fieldXml = "<Field Type='" + fieldType + "' Required='" + fieldRequired + "' DisplayName='" + fieldDisplayName + "' Name='" + fieldName + "'></Field>";
    var createdField = fields.addFieldAsXml(fieldXml, true, SP.AddFieldOptions.addFieldInternalNameHint | SP.AddFieldOptions.addFieldToDefaultView);

    currentContext.load(createdField);
    currentContext.executeQueryAsync(onSuccess, onProvisionFieldFail);
}

你能给我一些建议吗？

祝好，

Marian

- Marian Toader

Answer 1

试试这个。

var clientContext = new SP.ClientContext.get_current();
var list = clientContext.get_web().get_lists().getByTitle('ListName');

if(list) {
    var fldCollection = list.get_fields();

    var fieldLookup1 = clientContext.castTo(
        fldCollection.addFieldAsXml('<Field Name="FieldName1" Type="Lookup" DisplayName="My Lookup Field 1" List="Lists/MyLookupList" ShowField="Title" />', true, SP.AddFieldOptions.addToDefaultContentType),
        SP.FieldLookup
    );

    fieldLookup1.set_title("MyLookupField1");
    fieldLookup1.set_description("Lookup field 1 description");
    fieldLookup1.update();
    list.update();

    clientContext.executeQueryAsync(
        Function.createDelegate(this, this.onQuerySucceeded),
        Function.createDelegate(this, this.onQueryFailed)
    );
}

请告诉我它是否有效 ;)

祝你有美好的一天！

- Leonardo Rente

Answer 2

你应该考虑放弃使用NewForm和Editform.aspx的想法。自己编写表单并使用JSOM或WebApi添加/编辑列表项。

添加列表项的示例代码：

jQuery.ajax({
    url: "http://<site url>/_api/web/lists/GetByTitle('Test')",
    type: "POST",
    data: JSON.stringify({ '__metadata': { 'type': 'SP.List' }, 'Title': 'New title' }),
    headers: { 
        "X-HTTP-Method":"MERGE",
        "accept": "application/json;odata=verbose",
        "content-type": "application/json;odata=verbose",
        "content-length": <length of post body>,
        "X-RequestDigest": $("#__REQUESTDIGEST").val(),
        "IF-MATCH": "*"
    },
    success: doSuccess,
    error: doError
 });

参考资料：http://msdn.microsoft.com/zh-cn/library/office/jj164022(v=office.15).aspx

- phil