Google AppScript: Create Form using HTML, Publish Form as WebApp & Show data from Spreadsheet

This article shows: 1) How to create Google Form using standalone HTML file 2) Fetch data from Google Spreadsheet and populate Select box of the HTML Form 3) Populate second select box based on the value selected from first select box 4) Show result data from spreadsheet on form submit Basically, we have a spreadsheet … Read more

Javascript: Populate Select box OnChange with JS array/object

This article show how to populate one select box by selecting option of another select box/list. We will use a Javascript object. Each key of the object contains array as value. A first select box is populated with the Javascript object’s keys. Then when the value from the first select box is selected then based … Read more

Google AppScript: Create Form using HTML, Publish Form as WebApp & Email Response

This article shows: 1) How to create Google Form using standalone HTML file 2) Email form submitted data to any particular email address Create HTML file We create a Form in a new HTML File. Go to http://script.google.com Go to File -> New -> Html file Type the name of the file, e.g. form.html Write … Read more

Javascript: How to Submit form and Change form action?

This article will show you how to submit form and change form action using javascript. This is a very simple trick but it’s very useful and frequently used. Submit Form using Javascript HTML form <form name="myForm" action="http://google.com" method="get"> Search: <input type="text" name="q" /> <button onclick="javascript: submitForm()">Search</button> </form> Javascript function function submitForm() { document.myForm.submit(); } Change … Read more