I have designed small form using UiApp script which collects little information and after that should do a lot of Fusion tables data manipulation. I want all processing to be done after form is closed and application returned so user is not waiting for all Fusion tasks to be completed. I was planning to send data first to spreadsheet, trigger onFormSubmit and do all my Fusion tasks with trigger on onFormSubmit. But when I doPost() in UiApp apps script from my site onFormSubmit in the spreadsheet is not working. I am looking for SQL trigger like functionality to process data after record is inserted into Fusion table. Thank you.
1 Answers
0
votes
The forum submit event only fires when a user fills out a form attached to the spreadsheet. Inserting rows into the spreadsheet (or a fusion table) through Apps Script will not trigger the event. One solution is to use the Script services to schedule a one-time trigger, which can do your offline processing.
