Formatting Multiple selections

[AmyB]

I need to know how to build a rule for the following:

 

4 optional fields

Not prefilled

Each field 2 characters long (last 2 digits of a year, such as 09, 10, 11, 12)

 

1. If field is chosen, input " ’ " and addend to end of Name field

2. If single, end.

3. If multiple, place " , " between multiples

4. No commas on last entry

 

e.g. Amy Brown P ’10, ’11, ’12

 

The above example shows my name, "P" for Parent, and the graduating years of my children from a school. There will be 4 optional fields to choose graduating years from a pull down menu.

 

So if you select:

1 year, you'll see: Amy Brown P ’10

2 years, you'll see: Amy Brown P ’10, ’11

3 years, you'll see: Amy Brown P ’10, ’11, ’12

4 years, you'll see: Amy Brown P ’10, ’11, ’12, ’13

 

Any feedback for how to write a rule for this would be greatly appreciated!

[esmith]

I think I was on vacation when this post went up. I'm guessing you already solved your problem, but since I like to sharpen my JS skills, I'll post my solution anyway.

 

//Replace Field names with your field names for first 6 lines
var Grad1 = Field("1stChild");
var Grad2 = Field("2ndChild");
var Grad3 = Field("3rdChild");
var Grad4 = Field("4thChild");
var UserTitle = Field("Title");
var UserName = Field("Name")

//Edit/add case values as necessary
switch (UserTitle) {
  case "Parent": 
     var TitleCode = "P";
     break;
  case "Teacher": 
     var TitleCode = "T";
     break;
  case "Volunteer": 
     var TitleCode = "V";
     break;
  default: 
     var TitleCode = "";
}

var UserGrads = new Array();
if (Grad1 != "") UserGrads.push(Grad1);
if (Grad2 != "") UserGrads.push(Grad2);
if (Grad3 != "") UserGrads.push(Grad3);
if (Grad4 != "") UserGrads.push(Grad4);


function sortNumber(a, b) {
  return a - b;
}

UserGrads.sort(sortNumber);

var AllGrads = UserGrads.join(", '");

if (AllGrads != "") {
  var UserInfo = UserName + " " + TitleCode + " '" + AllGrads;
} else {
  var UserInfo = UserName + " " + TitleCode;
}

return UserInfo;