How do I sort the report with the last name?

  • keitijaroth
    Asked on October 11, 2019 at 4:38 AM
    Only one thing I can't figure out - I have a Full name field (vārds, uzvārds), in which the Last Name is the second box, but I can't get the results table to sort by last name. It will only do it by First name. Is there a way to do this with the field as it is, or do I need to make First Name and Last Name separate fields?
  • roneet
    Replied on October 11, 2019 at 4:48 AM

    May we know how are you extracting the reports? Are you exporting the submissions in the Excel sheet? If yes, then please follow this method to sort the last names alphabetically.

    Please check this Gif:

    How do I sort the report with the last name? Image 10

    Let us know if you have further questions.

    Thanks.

  • keitijaroth
    Replied on October 11, 2019 at 4:51 AM

     Aha! I see now that I need to export it to Excel. I was trying to do it in the Submissions page 1570783832Screenshot 2019 10 11 at 11 Screenshot 10using the little dropdown arrow at the right of the Vārds, uzvārds heading (not shown in this pic).

    All good. I can sort it in Excel.

    Thank you very much for your prompt, accurate and helpful replies!