First and last name fields?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Proper name entry formats - Do I need separate fields for first name and last name in order to show last name first and first name last in a pull down in another form?
Photo of John Stauffer

John Stauffer

  • 90 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
If you currently have a field called [Full Name] entered like
John Smith
You can make a new field to reformat that by formula to read Smith, John

Not tested but I think it would be

var text Last = Left([Full Name], " ");
var text First = NotLeft([Full Name], " ");

List(", ", $Last, First)

You can then adjust the Record Picker fields in your employee table Advanced settings to use that field  or else on the form where the drop down is, use a report which uses that field for its column.