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

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?

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.

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.

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.

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.

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?

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.

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.