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.
Coding Help Needed : WebHook integration not calling Google ScriptAsked by gillmantisnetworks on March 15, 2017 at 02:42 AM
My ultimate goal is to have JotForms integrate through a WebHook to a Google Script. My first step was to check the JotForms - Webhook worked so I called RequestBin and all my form data was visible there.
I then wrote some Google Script just to check that is was being called. I tried 2 options: The 1st was to send myself an email
MailApp.sendEmail("****@gmail.com", "My Snazzy App","My new app is now
The 2nd option was to post a line to my spreadsheet:
var ss = SpreadsheetApp.openById("###_kV22bQZGuJRbXIMJfpp-
I gave them access to the Google Sheets and Google email Advanced Services and in Google API Console activated GMail API, GoogleApps Script API and Google Sheet API.
Both options worked when I ran them from the Google Script editor. I then published them (Deploy as WebApp) and took the URL https://script.google.com/macros/s/######/exec and put is as the destination for my WebHook in the JotForm integration.
Although RequestBin was still updated neither of my options did anything when I submitted my JotForm.
Please help. Thanks Gill
Hi. I have not heard anything back from the developer team on this query. Please will you follow it up for me. Thanks.
Unfortunately, there is no update about the request. We cannot provide you any ETA at the moment. One of our Developer will get back to you as soon as their priority tasks are completed.
I have just found the solution. I think originally for the Google Script I was going into the Google Api Console and trying to do all sorts of complicated authorization things. I started again and did not add any Advanced Google Services or go to Google Api Console. I just ran the script once from the Script Editor and it asked me to allow access to the required eMail etc.
As I tried changing various things to get it working I changed to a doGet function which did not work. It took me a while to change it back to a doPost which does work.
Thank you for keeping us posted, gillmantisnetworks. We're glad that this has been sorted out. I suppose there is no need for the assistance of our development team on this matter so I guess it's safe to cancel now the escalation.
In any case, feel free to let us know if you have other questions.
Thanks and warm regards.