Create Web App Form on Google Sheets using Google Apps Script

In this video, I demonstrate how to create a simple web app form on Google Sheets using Google Apps Script.

Video, Code, and Documentation can be found at:

[carlosizquierdo]

Greetings from Venezuela. Today I have learned more than in college years.

Thanks. I hope to do all the videos of the channel.

[Niles-eiww]

Amazing! Gave me the building blocks to update my finance tracker easily.

[fishthy.]

Its 1yr ago published this video.. But it helps me a lot now...

[francoisleroux]

Hi. Followed your video exactly but when I paste the url to go to my web app the page is blank… what could be the problem?

[dorianduda]

Is it possible to reload the page after submitting the answers? How to do it?

[lokeshandlokesh]

Can you upload video on search data on Google sheets using html pages

[everydaytalkonlineenglishc]

Why would you do it this way rather than by using a google form and connecting it to a google sheet?

[Leo-igyl]

Where did you use the AddRecord() function in your HTML file???

[ibrahimcetin]

Hello. Thank you very much for the information you have given.
I wanted to know;
Once we fill out the form and send it, we can only print it on the 1st line. Is it possible to print this in a few lines?
For example, a person has 3 phone numbers. I want to write these numbers sub-bottom. Is this possible ?

[addinannas]

Hello.., can we do something like.. for the first name at colum B2 NOT starting at A1? By default it at A1 right

[stradacom]

Thank you for the tutorial. It would be interesting if you put your first name, last name and in addition to geolocate your location latitude and longitude and transfer all that to the Google Sheets, can you do it?

[vassilip.mironov]

Can you attach the PDF files to the form and save them in the G Drive under the created subdirectory {{Username}} from the form, saving the clients' contact data in the fields of the Sheet? Thank you.

[masterpigs]

Thread of code, hopefully.
No idea if youtube is going to mess up the tabbing etc.
Hopefully you don't mind. I may not type everything out.

[thomasanders]

I have a entry from created in sheet that i want to share to 10 user, so i duplicate the usersheet to 10 separate spreadsheet.

I wanna to make a web form login, that if User A login it goes to A spreadsheet so on

So the form is just a gateway to another sheet.

Can it possible?

[mcjuds]

01:46 output html
03:10 call .gs function

[mayursawant]

Sir how to modify these form by submited then redirect other page/landing page sir...please sir tell me.. and sir only ask form name, email, and number and one thing form supported to google sites

[outdoorlessons]

Thank you for the tutorial.
Do you have a video on how to extract checkboxes values from each row and update those checkboxes values to the assigned ID into Google Sheets.

Below is an example of HTML table from Web App (the table values 'ID' & 'Name' are extracted from Google Sheets)

ID Name Q1 Q2 Q3 Q4
1 John checkbox1 checkbox2 checkbox3 checkbox4
2 Helen checkbox1 checkbox2 checkbox3 checkbox4
3 Pete checkbox1 checkbox2 checkbox3 checkbox4

[murat.ondasyn]

HELLO MY FRIEND. Are there any restrictions for GOOGLE APPS SCRIPT as to how many times a script can be called by a website?
THANK YOU

[tazulislam]

Boss how to post multi input fields data in multi-row in one column at a time by one clicking?
example: column is "materials" ---items are "shoe, t-shirt, jacket, and so on.

[vinaysircsnip]

google.script.run. is unable to call the function. why?