![]() ![]() ![]() Change the sheet Id and name as appropriate ![]() Var sheet = SpreadsheetApp.openById('1KFVcrrCpiPKn7pOz2sQoI5IPjiPNlNKuHpykhlKA0fY').getSheetByName('Submissions') This solution will be tailored for a JotForm to Ultradox Trigger.įrom the New Ultradox > Name it 'Trigger' > Set a 1 minute Timer as the first block (otherwise the trigger will start before JotForm has a chance to write the new form data to your Sheet) > Insert a Google Apps Script - My Script Block > Click Create and Rename to "Trigger" > Replace lines 1 to 78 with the code below: // The following method will be invoked whenever Ultradox executes the script or any other Form, other than Google Forms to Trigger an Ultradox, you'll struggle as I have for the last 2 days putting together a proper solution to this question that was first asked in Nov 2012. If you'd like to use JotForm, Formstack, Zapier, etc. ![]()
0 Comments
Leave a Reply. |