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

    Data are not properly submitted to Google Spreadsheet

    Asked by tillmaj 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:

    http://www.jotformpro.com/form/41466862841966

     

    The fields that are not populating in the associated Google spreadsheet are those labeled "20XX-20XX Catalog"

     

    Page URL:
    http://www.jotformpro.com/form/41466862841966

    Screenshot
    JotForm google
  • Profile Image
    JotForm Support

    Answered by Welvin on May 28, 2014 at 02:02 PM

    Hi,

    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.

    Thanks

  • Profile Image

    Answered by tillmaj 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?

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 28, 2014 at 06:55 PM

    Hi,

    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

    Thanks!