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 not working with Integrated Google Sheets or Email Autosresponder

    Asked by bdabbs on May 25, 2017 at 03:33 PM

    Hello,

    I am using the Import App to import twenty-one (21) fields of data into my form.  

    Issue 1:

    Google Sheet integration is only working some of the time.  It seems that when I do a test import it works the first (1st) time but never the second (2nd) time.  In other words, I import three (3) rows of data from an existing excel spreadsheet and all of the data appears on the integrated Google Sheet.  However, when I try to import a second (2nd) set of data, the fields do not show on the Google Sheet.  It is not duplicate data.  All of the data is new and the headers stay the same.  There is nothing wrong with the headers.  They all match the Import App.  

    I have been able to fix this by breaking the integration, renaming the form, renaming the excel target sheet, renaming the Google Sheet and deleting all the prior submissions.  However, after the first (1st) import, it will not populate any new import attempts.  

    I closed the programs, renamed, etc.  

    Issue 2:  I have the Email Autoresponder set to mail the party email shown in the determined field.  However, it does not work.  I use this feature all of the time without issue.  I set up a lot of forms with emails and added conditions.  This is just straight forward but is not working.

    Can anyone help me?  

    Is the Autoresponder not reacting because the data is imported rather than "input?"

    Are the Google Sheet Integration and/or Import App not capable of multiple imports to the same sheet?  

           ***(no new fields or headers.  the field data is the only change.  e.g. a different name, zip code etc.)

     

    Thank you in advance for any assistance,

     

    Bryce 

      

  • Profile Image
    JotForm Support

    Answered by Welvin on May 25, 2017 at 04:09 PM

    You have to consider the number of submissions in the form and the number of column per submission. The form might take time to sync the data into the integrated Google Spreadsheet file. Also, I don't think this is the best approach. I would suggest importing the data first before integrating the form with Google Spreadsheet. This way, all of the data will be added to a single sheet when integrating.

    As for the autoresponder/notification, this feature will only work for new submissions. The import app cannot trigger the autoresponder in the form after the import process. 

    I hope that helps. Let us know if you need further assistance.