How do I sort the report with the last name?

  • Profile Image
    keitijaroth
    Asked on October 11, 2019 at 04: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?
  • Profile Image
    roneet
    Answered on October 11, 2019 at 04: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:

    1570783675888888888.gif

    Let us know if you have further questions.

    Thanks.

  • Profile Image
    keitijaroth
    Answered on October 11, 2019 at 04: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.49using 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!