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

    Google Spreadsheet script not being executed when a new record is added to it

    Asked by daniellewis on January 02, 2015 at 02:12 PM

    Hi there,

     

    I need a Google Apps Script to execute upon form submission. When I submit a jotform, the info gets added to a new row of the Google spreadsheet it’s linked to, but the “On Change” trigger I added doesn’t seem to activate. (It triggers properly when I make a manual edit to the spreadsheet). Does anyone have a solution or workaround for this? I think that it’s not triggering because of a bug in Google Sheets; see https://code.google.com/p/google-apps-script-issues/issues/detail?id=4391 . If my assessment is correct and you don’t have a solution/workaround, please star the issue linked to above in order to convince Google to fix it. Thanks.



    This is a re-post of a comment on How to Integrate Form with Google Spreadsheet

    Page URL:
    http://www.jotform.ca/form/43516772148257

    JotForm workaround Activate thanks Google spreadsheet trigger form bug
  • Profile Image

    Answered by raul on January 02, 2015 at 02:45 PM

    For what I understand from the provided link the issue is happening on Google's side. We do use their API to add new rows to the sheet when a new submission is captured in your form.

    Unfortunately, it's out of our scope the priority that Google is giving to this bug. Hopefully, they can provide a fix for it soon.

    Let us know if you need further assistance.
    Thanks.