Skip to main content
Participant
November 1, 2017
Answered

last name,first name,middle name

  • November 1, 2017
  • 1 reply
  • 1181 views

     How do I make lastname,firstname,middlename come out like first name, middle name, last name?

Doe,John,Dee look like John Dee Doe

This topic has been closed for replies.
Correct answer try67

Use this code as the custom calculation script of the field where you want to show the result:

var fields = ["first name", "middle name", "last name"];

var values = [];

for (var i in fields) {

    var f = this.getField(fields);

    var v = f.valueAsString;

    if (v!="") values.push(v);

}

event.value = values.join(" ");

1 reply

try67
Community Expert
Community Expert
November 1, 2017

Do you mean that you want to combine the values of three fields into one field?

nwuerchAuthor
Participant
November 1, 2017

Yes please.

[Personal info removed by Moderator]

Sent via the Samsung Galaxy S®6 active, an AT&T 4G LTE smartphone

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
November 1, 2017

Use this code as the custom calculation script of the field where you want to show the result:

var fields = ["first name", "middle name", "last name"];

var values = [];

for (var i in fields) {

    var f = this.getField(fields);

    var v = f.valueAsString;

    if (v!="") values.push(v);

}

event.value = values.join(" ");