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

    How can I trigger a Google Spreadsheet when a JotFrom arrives?

    Asked by HLtexas on October 18, 2014 at 10:40 PM

    What I want to do:

      1. Webform collects information and sends it to a Google spreadsheet. 

      2. When the form updates, it triggers a custom script that sends the data to an email address.  

    I can do this using Google Forms, but when I use a Jot Form, the trigger is not pulled.  How can I set up a trigger in the spreadsheet that will be activated by the JotForm?

    Page URL:
    https://sites.google.com/a/hltexas.com/tessera/

    JotForm form updates custom script and
  • Profile Image

    Answered by Ben on October 19, 2014 at 06:48 AM

    Hi,

    I would suggest taking a look at the installable Google Apps triggers in Google Spreadsheet.

    You can see more about this here:

    https://developers.google.com/apps-script/guides/triggers/installable

    and I believe that you should use them with onPOST. You can see more about that here:

    https://developers.google.com/apps-script/guides/triggers/#getting_started

    Do let us know how it goes and if you have any further questions.

    Best Regards,
    Ben