- tillmajAsked on May 28, 2014 at 12:17 PM
I have created a JotForm to replace an Adobe FormsCentral form. I'm having my JotForm entries feed to a Google spreadsheet.
I need to manually move the entries that were collected in the previous Adobe form into the Google spreadsheet that Jot Form will now populate. I have done some of this migration. I then tested the JotForm to be sure that new entries (submitted via the JotForm) are coming in OK. When I did this, I did get almost all of the data for the new entry in the Google spreadsheet, with the exception of several fields. Can you help me figure this out?
Here's the JotForm:
The fields that are not populating in the associated Google spreadsheet are those labeled "20XX-20XX Catalog"
- JotForm SupportWelvinAnswered on May 28, 2014 at 02:02 PM
We don't advise doing any modifications to the spreadsheet that was generated by the Google Spreadsheet Integration. Doing any modification, especially on the first row would break the integration. Also, manually adding contents to the sheet isn't adviseable.
Please do this instead:
1. Remove the current Google Spreadsheet integration
2. Import the data that was submitted to the old form you have (Adobe Form) to your existing form using our Import Data App: http://apps.jotform.com/app/import_data.
3. After importing the data, make sure to check if they have been successfully added to your form.
4. Re-integrate your form to Google Spreadsheet. This time, make sure to do not change something on the spreadsheet.
Hope that helps. If you require any further assistance, feel free to contact us.
- tillmajAnswered on May 28, 2014 at 04:02 PM
A follow up question, then - I added non-visible text boxes to my form so that the users can enter data in the fields these will create in the Google spreadsheet -i.e., we might wish to put notes on progress or a date something is completed, etc. Would this interfere with the integration?
- JotForm SupportEltonCrisAnswered on May 28, 2014 at 06:55 PM
My test proves that it is possible to edit and enter data on the spreadsheet, so I think that's fine. But keep in mind that re-integrating your form to Google Spreadsheet will not carry the notes you manually added to the sheet so you have to copy and paste it to the new integrated spreadsheet.
My suggestion would be to add a tab sheet on the integrated spreadsheet and then add your notes there so the integrated sheet will not break in any way.
You can also copy the data to the tab sheet from the main sheet using formula. e.g. =Submissions!A1