Create a Custom HTML Form for Google Sheets using Google Apps Script.

In this video, I show steps on creating a Custom HTML Form for google sheets using Google Apps Script.
Video, Code, and Documentation can be found at:
codewithcurt.c...

[@daytodatainc]

I have been searching for this exact example for about 2 hours!!! You are a life saver! This is exactly what I needed to help complete something I'm working on. Keep it up, your other videos are spot on! Great practical, yet powerful examples!!!

[@jenni8075]

Wow just want to say thank you! I began using UserForm on excel several years ago and after losing interest in coding again I gave up. I have also been looking for this for roughly 2 years and I guess my search was not detailed enough to where I was being redirected to the correct videos. lol. After using a coding program I said "wow this is what I need" and found your video thanks so much. Sharing your helpful videos now because your video is the only one that I tried that actually works. =) Great job!

[@philaman1972]

Excellent! You break it all down into simple, bite-sized chunks! Thanks a lot!!

[@elizabethhankins8578]

Is this outdated? I can't get my Add button to work.

[@newborn7850]

Pls do one video on my request how to Fetch data from Google spread sheet and display in an HTML page one row at a time , with a next button in HTML Page to view next record. Pls Pls

[@thetechnologyforteachersan1085]

You are awesome and intelligent. I try this and it run succesfully. Thank you

[@bongcomputrick3937]

Please create a video on user permissions and restrictions on google sheet as well as hidden and veryhidden sheet option

[@jaygurjar5915]

My apped row is not working

[@intrealestate]

Straight forward. Thanks,

[@samartupathong7919]

Thank you very much. Video is easy explain

[@yuwish6320]

onclick event doesn't work. Click it all day long. Nothing changes. Manually activating the AddRecord function works fine. Apparently onclick events in the HTML are no longer supported.

[@mrjenkins8080]

Can you use the HTML form you created on a Google Site for example?

[@jfresh2054]

How do you keep adding questions? Also I want a header tables and a background color?

[@wirot125]

Thank you very much.

[@tongthokworld5466]

Make a button for upload ducuments

[@newborn7850]

how to publish that form online? or Share Link of the form ?

[@CikguIT]

I put my HTML form on the web server. but when I submitted it, the data is not stored in GS. pls help

[@bfpenner]

I can seem to get my html and my gs to work together. Can't call functions. ??? Any ideas?

[@newborn7850]

How to add check box , Multiple choice button, Radio Buttob and Picture Upload . Thanku

[@ajsantos3739]

Do you have a tutorial for an edit function HTML form?

[@kenjichairilyuwono3912]

Add button doesn't work for me. Help

[@teruyaalmeida]

why can't i run "scrip.run"?

[@sistana]

...If add autofocus to the inputbox. Anyway thanks, god job!!

[@deepaunnikrishnan2123]

is it possible to create a quiz form without "back" button?

[@vijayshelar1857]

script function is not working how can i solve this

[@jonathangomez9901]

How can I add more inputs after name?

[@tazulislam2698]

How to submit multi name in one column at a time?

[@newborn7850]

how to search a particular record from HTML page by Id or Name in googlesheet , html form with text box and search button searching record in Google sheet, Thanking you Lots

[@NamHaVblog]

thanks

[@khonlieu6619]

Will this form also be available on mobile google sheet (iOS)?

[@hengkiirawan239]

How to make button to go other sheet

[@CodeWithCurt]

The addRecord Function holds the sheet name in which you are adding the record to.

[@hengkiirawan239]

@@CodeWithCurt thanks

[@littleclover2334]

Hi Curt! I have a question sir. What if i the html file automatically opens when the google sheet opens, is it possible? Thanks in advance😊

[@DanielEscasa]

My guess is, add to the _onOpen()_ function. function onOpen(e) { addMenu(); startForm(); } Disclaimer: Haven't tried this yet, may use it in a project I'm working on now

[@CodeWithCurt]

HTML and javascript code from Video below: function AddRow() { var name = document.getElementById("name").value; google.script.run.AddRecord(name); } Name:  

[@Mr_YaYa43]

how to create button when onClick, goto send a whatsapp message?