Relative Content

Tag Archive for formsurlparameters

Google Forms script to get data from form URL or pre-filled field

A Google form is opened with an url ending: &entry.xxx=102>
The number (102) comes from a sheet and I can pre-fill a form field with the number but I want to do arithmetic on it first.
Is there a script that will give the number either from the url or from the form field that is pre-filled. I’ve tried things like: form.getItems(); and form.getResponses();