display two columns in Manage Plumsail Lookup

Posted by RMIC - Oct 1 ’15 at 09:38

• 

  rostislav

  Moderator

  Member for: 7 years 10 days
  #1 by rostislav Oct 2 ’15 at 04:33

  To display values of two columns inside the Cross Site lookup dropdown box:

  1. Add the fields to the Request query. Here I'm adding two fields called 'anothercolumn1' and 'anothercolumn2' to my query:

  function (term, page) {
    if (!term || term.length == 0) {
      return "{WebUrl}/_api/web/lists('{ListId}')/items?$select=Id,{LookupField},anothercolumn1,anothercolumn2&$orderby=Created desc&$top=10";
    }
    return "{WebUrl}/_api/web/lists('{ListId}')/items?$select=Id,{LookupField},anothercolumn1,anothercolumn2&$orderby={LookupField}&$filter=startswith({LookupField}, '" + encodeURIComponent(term) + "')&$top=10";
  }
  

  2. Add the fields to the item format function:

  function(item) {
    return '<span class="csl-option">' + item["{LookupField}"] + '  ' + item['anothercolumn1'] + '  ' + item['anothercolumn2'] + '</span>'
  }
  

  Note that the names of the fields must be InternalNames, not titles (you can check in Forms Designer the internal name for a field).

  If you want to also display multiple values inside the actual box (not the dropdown list), then you can add a calculated field with a formula like this:

  [anothercolumn1]&" - "&[anothercolumn2]
  

  and use it as the lookup field.

  If you then want to filter the result set based on multiple fields check the following forum thread, especially starting from message [#7] http://forum.spform.com/forms-designer-for-sharepoint-20/cross-site-lookup-loading-failed-error-34396

  link flag
• RMIC

  Member

  Member for: 7 years 6 days
  #2 by RMIC Oct 15 ’15 at 07:42

  [#1]: Thanks!

  link flag

Show more messages