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

    Splitting full name into separate fields on export

    Asked by aspirebrokers on April 05, 2016 at 10:08 PM

    Hi Guys,

    I like the formatting and look of the "Full Name" field however I need the data to come out of the system in separate fields.  Is there a way I can do this?

  • Profile Image
    JotForm Support

    Answered by liyam on April 06, 2016 at 12:16 AM

    Hello aspirebrokers,

    If you're simply going to split the parts of the full name for the purpose of separation on email alerts, it can be done by modifying the email alert template. And for the specific full name field, separate it with a colon. Example: {fullName:first} {fullName:last}

    When using {fullName} alone, it will show the proper full name such as John Doe. But, when using {fullName:first}, it will only print John. However, this is only limited to printing the information to your email alerts or your thank you page. 

    So if you wish for the name to split in an excel data, you will have to make use of the regular text box instead and have the fields set for each part of the name per text box. This way, each part of the name will be separate from each other.

    Please let us know if you have further questions.