5

I am new to Google apps script and need help. I an trying to achieve the following -

Set a trigger for lost-focus of a textbox in google form. The code in this event will be A. Get the value of a textbox B. Set the value of a textbox

Zig Mandel
  • 19,196
  • 5
  • 24
  • 35
Sasmit
  • 140
  • 1
  • 10

2 Answers2

6

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.

Cameron Roberts
  • 6,786
  • 1
  • 18
  • 29
  • 1
    Its correct that its not supported natively. However there are 3rd party tools or ways to copy the generated form and place the html/javascript in your own hosting. This lets you modify the javascript. Example: http://sneakysheep.com/google-docs-form-tool-version-2/ – Zig Mandel Apr 14 '15 at 18:59
0

Option 1) Try 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

Paul Verest
  • 55,983
  • 44
  • 191
  • 313