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...
Пікірлер: 41
@daytodatainc3 жыл бұрын
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!
@philaman19723 жыл бұрын
Excellent! You break it all down into simple, bite-sized chunks! Thanks a lot!!
@elizabethhankins85783 жыл бұрын
Is this outdated? I can't get my Add button to work.
@newborn78504 жыл бұрын
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
@thetechnologyforteachersan10853 жыл бұрын
You are awesome and intelligent. I try this and it run succesfully. Thank you
@bongcomputrick39374 жыл бұрын
Please create a video on user permissions and restrictions on google sheet as well as hidden and veryhidden sheet option
@jaygurjar59153 жыл бұрын
My apped row is not working
@intrealestate4 жыл бұрын
Straight forward. Thanks,
@samartupathong79193 жыл бұрын
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.
@mrjenkins80803 жыл бұрын
Can you use the HTML form you created on a Google Site for example?
@jfresh20543 жыл бұрын
How do you keep adding questions? Also I want a header tables and a background color?
@wirot1253 жыл бұрын
Thank you very much.
@tongthokworld5466 Жыл бұрын
Make a button for upload ducuments
@newborn78504 жыл бұрын
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
@bfpenner3 жыл бұрын
I can seem to get my html and my gs to work together. Can't call functions. ??? Any ideas?
@newborn78504 жыл бұрын
How to add check box , Multiple choice button, Radio Buttob and Picture Upload . Thanku
@ajsantos37392 жыл бұрын
Do you have a tutorial for an edit function HTML form?
@kenjichairilyuwono39122 жыл бұрын
Add button doesn't work for me. Help
@teruyaalmeida3 жыл бұрын
why can't i run "scrip.run"?
@sistana2 жыл бұрын
...If add autofocus to the inputbox. Anyway thanks, god job!!
@deepaunnikrishnan21233 жыл бұрын
is it possible to create a quiz form without "back" button?
@vijayshelar18573 жыл бұрын
script function is not working how can i solve this
@jonathangomez99013 жыл бұрын
How can I add more inputs after name?
@tazulislam26983 жыл бұрын
How to submit multi name in one column at a time?
@newborn78504 жыл бұрын
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
@NamHaVblog3 жыл бұрын
thanks
@khonlieu66192 жыл бұрын
Will this form also be available on mobile google sheet (iOS)?
@hengkiirawan2394 жыл бұрын
How to make button to go other sheet
@CodeWithCurt4 жыл бұрын
The addRecord Function holds the sheet name in which you are adding the record to.
@hengkiirawan2394 жыл бұрын
@@CodeWithCurt thanks
@littleclover23343 жыл бұрын
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😊
@DanielEscasa2 жыл бұрын
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
@CodeWithCurt4 жыл бұрын
HTML and javascript code from Video below: function AddRow() { var name = document.getElementById("name").value; google.script.run.AddRecord(name); } Name:
@Mr_YaYa432 жыл бұрын
how to create button when onClick, goto send a whatsapp message?