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

    Using Full Name field instead of two separate fields for First and Last Name

    Asked by lumossolar on April 23, 2015 at 12:36 PM

    Another question, somewhat related.  I'm a transfer from Adobe Form Central.  For many of my forms, I'm collecting contact information - names, phone numbers, addresses, emails...

    For the email addresses, the transfer is fine.  However for the rest, transfer has not been as seamless...

     

    i.e.

    Old (adobe) form had two separate fields for name: First Name & Last Name

    Jot Forms has the ability to use a the "Full Name" entry - I like this interface much better.

     

    Rather than going into every single one of the old entries to copy and paste into your interface, any suggestions as to how this can auto-populate during a transfer?  Or can I download into excel and re-upload?

    full name
  • Profile Image
    JotForm Support

    Answered by Welvin on April 23, 2015 at 12:45 PM

    Hi,

    I'm not sure if I understand the question. Did you mean to say that you want to transfer the First and Last Name data from Adobe Form Central into the Full Name field of your Jotform form? So instead of transferring data into two separate fields, you want to combine them into one field? Is this correct?

    Or, did you meant to say that instead if using First and Last Name fields, you want to use the Full Name field as a whole when importing the forms from Adobe Form Central to Jotform?

    When importing a form from Adobe Form Central, most of the fields will be copied and since this is an automated process, there's no way you can change the field types in the form until they will be available in your account for viewing/editing.

    Any further explanation about this matter is greatly appreciated.

    Thank you.

  • Profile Image

    Answered by lumossolar on April 23, 2015 at 01:06 PM

    Hi,

     

    In the case of the names, I'm speaking of the latter: "

    "...if using (seperate) First and Last Name fields, you want to use the Full Name field as a whole when importing from Adobe Form Central to Jotform"

     

    I understand it's an automated process.  And I really appreciate that you have come up with an excellent way to import my forms and past submissions.

     

    However, the frustration I'm having is editing information that's already been entered in.  For example...the names.

    Your "Full Name" interface looks much cleaner, and I can't replicate that using the two separate inputs that are coming from what I had in Adobe Form Central.  So I would like to convert over to your "Full Name" field.  However, when I go into the "Submitted" area of each form, instead of very easily being able to make edits into a spreadsheet like interface (as found in Adobe Form Central), I have to open up each individual form, make edits and resubmit.  A lot of extra clicks, time and also a new "notification" email is sent each time.

     

    For a some forms with minimal entries, this is not an issue.  However, for some of our forms, we've had over 100 entries.

     

    Any suggestions?

     

    Thank you.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on April 23, 2015 at 02:04 PM

    If you want to edit your submissions without re-submitting the form I think using this import data tool might help: http://apps.jotform.com/app/import_data

    To proceed, do this:

    1. Download the excel file. Make sure you do this before doing any other step.

    Make a backup copy of the file in your drive.

    2. Clone the form see here how

    3. Apply he proper modifications in the data, use the copy of the file, this the one you should upload later on. 

    For example:  If this is about converting the full and last name into a single field 

    - Add our Full Name field to the clone of the form and remove the old ones, such as on this example:

     

    Then save the form.

    4. Now, proceed to upload the modified file into the modified form, using the import_data app

    And that should be it!

    Please let us know if the proposed workaround accomplishes what you are looking for.

  • Profile Image

    Answered by lumossolar on April 23, 2015 at 06:20 PM

    Unfortunately, that didn't work very well and ended up overriding all the existing data and now I have a blank database.

     

    I had to erase all the submission to try and get things functioning again.  Is there anyway to re-load just the submitted data from Adobe Form Central for a select form?  Right now, if I try and upload from Adobe Forms Central, it wants to upload all my forms and override any changes I may have made to other forms that I am currently using on Jotforms.

     

    Thank you.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on April 23, 2015 at 08:04 PM

    As explained in step 2, you should have made a clone of the form. Then download the data from the original and also make a copy (as a backup)

    Make the modifications in the clone, NOT the original form. Which also contains the data and should remain intact. The clone is empty. That's how it's created.

    Then you should have uploaded the updated data into the modified form (which is the clone of the original form)  as explained in step 4.

    4. Now, proceed to upload the modified file into the modified form, using the import_data app

    Can you

    Can you please tell us what is the original form ID or Form Name so we can help with that?

  • Profile Image

    Answered by lumossolar on April 24, 2015 at 11:02 AM

    My apologizes Jeanette, then it was my fault for not properly reading your instructions.

     

    However, I did figure out how to re-upload the data (somewhat).  But the import doesn't properly format the "Full Name" boxes - it places the entire name (first and last) into the last name box.

     

    http://www.jotform.us/form/50825312956154

     

    Also, the import would not/cannot maintain the date of submission, which is also a component I wanted to keep.

    At this point though, what I'd simply like to do is re-import the one form (and data) from Adobe Forms Central.  Does your Adobe Forms Central import tool have the ability to import a single form and not all the forms?

     

    Thank you.

     

     

  • Profile Image
    JotForm Support

    Answered by BJoanna on April 24, 2015 at 01:18 PM

    You can import one form from Adobe form central. 

    You can see here more details about it:

    http://www.jotform.com/blog/129-Import-Both-Your-Forms-and-Responses-in-a-Single-Step-from-Adobe-FormsCentral  

    After it is possible to import submissions to Jotform by first exporting as CSV/Excel and then using our import data app:

    https://acrobatusers.com/tutorials/how-to-export-form-responses-from-formscentral 

    http://apps.jotform.com/app/import_data 

    Hope this will help. Let us know if you need further assistance.