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 split first name & last name data from the Fullname Quick Tools field?

    Asked by sross on November 17, 2015 at 10:53 AM

    Hi I used the fullname quick tools field and when I integrate my form with a spreadsheet it combines first & last into a single field but I need to split them. Is this possible or do I need to create 2 separate fields?

    Page URL:

  • Profile Image

    Answered by Boris on November 17, 2015 at 01:09 PM

    When using the recommended Full Name field from the Quick Tools to collect names of your users, the name will be forwarded to the integrated spreadsheets in a single column - because the full name field is a single question, and each form question goes to one column.

    If you want to have the name data forwarded to the integrated spreadsheet in separate columns, you would have to use two separate form fields instead. You can use 2 Text Box fields, and ask for the first name in one, and for the last name in the other Text Box field.

    I can see that this is already done in your last edited form: https://form.jotformpro.com/form/52316035402947

    Please let us know if you need further assistance, and we will be glad to help.