Discussions

Expand all | Collapse all

First and last name fields?

  • 1.  First and last name fields?

    Posted 05-29-2018 16:49
    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?


  • 2.  RE: First and last name fields?

    Posted 05-29-2018 16:55
    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.