Skip to main content
Question

First and last name fields?

  • May 29, 2018
  • 0 replies
  • 38 views
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?
    This topic has been closed for replies.

    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.


     
    Terms & ConditionsAccessibility statement