What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Can you sort your submissions by last name even though you use the full name field?

    Asked by CalhounWarhawks on October 03, 2012 at 03:27 PM

    I like the full name field and it asks for first and last in 2 spots, but on the Excel spreadsheet they are all together and I can't sort by last name.  Currently, I just have 2 fields -- 1 for first name and one for last.  However, this complicates the way I am using Dropbox integration.  I would for it to name the submission that is downloaded in Dropbox by the name.  If I use the Full Name field, it wouldn't be a problem except that it would sort by first name.  Since I currently have the name separated, I can have the submission by the Last Name but I have people that will be using the form that have the same last name, so if 2 people with the last name of "Smith" they replace each other. 

    Any suggestions?

    Page URL:

  • Profile Image
    JotForm Support

    Answered by NeilVicente on October 03, 2012 at 03:39 PM

    There is no way around the Dropbox folder naming convention, so I would suggest that you use Full Name field for naming the files/folders.

    In your submissions' Excel file, it is possible to split the full name values into first name and last name columns by using Excel's built-in Convert to Text Columns Wizard.

    If you need further help on this topic, please feel free to ask.


  • Profile Image

    Answered by CalhounWarhawks on October 03, 2012 at 03:58 PM

    Hey thanks so much!

  • Profile Image
    JotForm Support

    Answered by NeilVicente on October 03, 2012 at 04:04 PM

    Glad to be of help. Have a good day!