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

    Triggering a script on Google Spreadsheet

    Asked by dkanotister on June 11, 2015 at 12:06 PM

    Hello,

    I have implemented Google Apps script triggers for all types there are (simple, installable), both with change/edit/form submit types. They work fine when I change the sheet.

    However none of them work when JotForm submits a new row to the sheet.

    Is this supposed to work? Or is the integration done in such a manner that the Google Apps Script triggers are not ever executed?

    JotForm form submit google spreadsheet integration
  • Profile Image
    JotForm Support

    Answered by BJoanna on June 11, 2015 at 01:51 PM

    After some investigation regarding your issue and I am afraid that google triggers will not work when new submission come to the Google spreadsheet. 

    This can be useful link where this topic is covered and you can try with proposed solution:

    http://stackoverflow.com/questions/16183127/trigger-google-apps-script-when-jotform-submitted-and-integrated-to-spreadsheet 

    You can also check some of other solutions.

    Hope this will help. Let us know if you need further assistance.