CODEWITHSUNDEEP
formsgoogle-apps-scripttriggersgoogle-sheetsgoogle-forms
Kirill
Kirill

Reputation: 9

Script triggers for a Google spreadsheet

This a question about using script triggers for a Google spreadsheet which is populated through a custom form. The workflow is the following:

The problem is that this trigger works fine if you make any edits manually in the spreadsheet. But it stays idle if a new data from web form arrives, it doesn't start csv conversion function. So a trigger doesn't consider new inputs from form as edits. I tried other triggers - onChange and onFormSubmision but no luck as well.

However if I use standard Google Form but not a custom one for the same workflow a trigger onFormSubmission works perfect. The problem with that is that there's no upload function in standard Google Form and that's why I build my custom one.

I tried Formpl.us service which can add upload button but then I have the same result as with my own form. New submissions are ignored by the triggers.

So the questions is how to make triggers act when a new data from custom web form arrives to a spreadsheet.

Upvotes: 0

Views: 1007

Answers (2)

ike
ike

Reputation: 1

https://developers.google.com/apps-script/reference/script/form-trigger-builder

here's the trigger documentation but something like this should work

var form = FormApp.openById('1234567890abcdefghijklmnopqrstuvwxyz'); ScriptApp.newTrigger('myFunction') .forForm(form) .onFormSubmit() .create();

Upvotes: -1

Bjorn Behrendt
Bjorn Behrendt

Reputation: 1264

I would suggest adding a "Status" column and enter something in that column for every line that your trigger has processed. Then set a time-based trigger to look for any empty status columns and then process just that line.

Upvotes: 1

Related Questions