Triggering a script on Google Spreadsheet

  • Profile Image
    dkanotister
    Asked 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?

  • Profile Image
    BJoanna
    Answered 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.