Converting Non-User Name Fields
I am trying to convert a field that is not a user field to be able to read first name, middle name, last name. I have a field that reads last name, first name middle name/initial (Smith,John Q). I wa...
Forum Discussion
Can you describe the "...field that reads last name, first name middle name/initial?"
Is that a formula field text reading from three regular text entry fields, first name, etc?
- MarkShnier__You
Qrew Legend
Try this as a formula text field.
var text PartOne = Part([my last first field], 1, ",");
var text PartTwo = Part([my last first field], 2, ",");
List(" ", Trim($PartTwo), Trim($PartOne))
