Multi-select Lookups

Follow

Phong Nguyen

• March 21, 2018 22:22

Hello. I am trying to create a Project Name and a Project Number field. Both are multi-select fields. However, Number is dependent on Name and have a 1:1 relationship.

For example:

Project A = 1, Project B = 2, Project C = 3, etc.

 

If the user selects Name = Project A, the Number would populate 1. If the user also selects Project B, the Number would populate 1;2.

Is this even possible?

0

• 

  Karl Makatenas

  • March 22, 2018 13:28

  Although the exact method is eluding me right now, I'm sure you can do something similar using Rules to populate a text field.  This seems very simple using Javascript, so here's a quick bit of untested code for you to launch when ProjectName fires a Change event:

  function PopulateProjectNumber() {

  var projects = $("#ProjectName");
  var nums = [];
  for (var i = 0; i < projects.length; i++) {

  nums.push(projects[i].value);

  }
  var projectNums = nums.join("; ");
  $("#ProjectNumber").value = projectNums;

  }

  0

  Comment actions Permalink

Please sign in to leave a comment.