First Name, MI, Last Name and Suffix into one field
One more question (if you don't mind):
What if the Person's Name has a Middle Initial?
event.value = this.getField("First Name").valueAsString + " " + this.getField("Middle Initial").valueAsString + " " + this.getField("Last Name").valueAsString;
But, if there is "No" Middle Initial, there will be 2 spaces between the First and Last Name
Similarly, I have a "Suffix" field, (ex. John Q. Public, Sr.)
I'd like a (.) period if there is a Middle Initial and a comma if there IS a suffix, but NO period or comma if there is no Middle Initial or suffix.
Is this possible?
