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

    Import App - Successful but it's not refreshing the Google Sheet

    Asked by gemai on November 03, 2015 at 06:32 PM

    Hi there

    I have imported data into one of my forms using the Import App (http://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm).

    The process went fine and now my form has the correct number of submissions (6 existing ones + 206 imported from the Excel file). But when I go to the associated Google sheet, I only can see my 6 original submissions, not the imported ones. Why is that?

    Cheers

       Gema

    import app google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Charlie on November 04, 2015 at 01:27 AM

    Hi,

    You might need to remove the Google Spreadsheet integration then re-integrate it again so that the imported submissions will be loaded in the spreadsheet.

    I believe the spreadsheet updates based from the submission it actually receives, if you have imported the submissions using the Import Data app, then it will probably not reload them in the spreadsheet.

    Let us know if re-integrating will reload all the submissions in the sheet.

  • Profile Image

    Answered by gemai on November 04, 2015 at 03:26 PM

    Hi Charlie

    Yep, I've tried that but still the same: the GSheet only shows the original submissions.

    I am doing this exercise because we want to replace our existing form (integrated with a GSheet). My original idea was to put the new form in place, integrate it with a new GSheet (changes in column names, additional columns) and then import the existing data in the new format to the new GSheet. In the past I copied the data instead of importing it and I eventually lost all the copied data - not the new submissions - when I had to reintegrate the form.

    What's the best approach there?

  • Profile Image
    JotForm Support

    Answered by Mike on November 04, 2015 at 07:03 PM

    Import is based on our API, and such imported entries do not trigger emails and integrations.

    The following scenario should work.

    1) Import entries to the form.

    2) Enable integration. If it is already enabled, you will need to completely remove it and then add it back. It will import all the entries.

    3) Add changes to your integrated spreadsheet if needed (you should not change existing label names). Also, form modifications are not recommended for customized spreadsheets. If you update any field label on the form, associated google spreadsheet will be changed back to its default format with the next form submission.