Run javascript as the form is being filled by users

Question

I am new to Google Apps Script and need help. I am trying to achieve the following:

Set a trigger for lost-focus of a textbox in Google Forms. The code in this event will be

1. Get the value of a textbox
2. Set the value of a textbox

Answer 1

Unfortunately this is not currently possible with Google Apps Script and Google Forms. Apps Script can be triggered by the submission of a Form, but it cannot interact with the Form in the users browser.

It is possible to build a form entirely in Apps Script (using HTML) which would allow you full control over the user experience, but you lose access to the functionality provided by Google Forms.

Answer 2

Option 1) Try Google Apps Script

• Do more with add-ons and scripts
• Overview of Google Apps Script

Option 2) While adding arbitrary JavaScript is not supported by Google Forms, it is still possible to get sources of your form, extend with extra scripts and host on your site with results still posted to Google Forms/Google Sheets

See

• How to get JS script of a Google form?,
• Google Forms + Google Sheets + Google Apps Script = ❤. Easy Database Solution for Static Websites