First and last name fields?

  • 0
  • 1
  • Question
  • Updated 6 months 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 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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.