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

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 42

  • @daytodatainc
    @daytodatainc 3 роки тому +1

    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
    @jenni8075 2 роки тому

    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
    @philaman1972 3 роки тому

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

  • @elizabethhankins8578
    @elizabethhankins8578 3 роки тому +5

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

  • @tallyerptutorials
    @tallyerptutorials 2 місяці тому

    custom menu is available in my google sheet . How to enable it

  • @thetechnologyforteachersan1085
    @thetechnologyforteachersan1085 3 роки тому

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

  • @newborn7850
    @newborn7850 4 роки тому +3

    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

  • @mrjenkins8080
    @mrjenkins8080 3 роки тому +1

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

  • @CikguIT
    @CikguIT Рік тому

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

  • @Jfresh55
    @Jfresh55 3 роки тому +1

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

  • @bongcomputrick3937
    @bongcomputrick3937 4 роки тому +1

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

  • @samartupathong7919
    @samartupathong7919 3 роки тому

    Thank you very much. Video is easy explain

  • @CodeWithCurt
    @CodeWithCurt  4 роки тому +1

    HTML and javascript code from Video below:



    function AddRow()
    {
    var name = document.getElementById("name").value;
    google.script.run.AddRecord(name);
    }



    Name:  

  • @ajsantos3739
    @ajsantos3739 2 роки тому

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

  • @yuwish6320
    @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.

  • @newborn7850
    @newborn7850 4 роки тому +1

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

  • @intrealestate
    @intrealestate 4 роки тому

    Straight forward. Thanks,

  • @khonlieu6619
    @khonlieu6619 3 роки тому

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

  • @bfpenner
    @bfpenner 3 роки тому

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

  • @deepaunnikrishnan2123
    @deepaunnikrishnan2123 3 роки тому

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

  • @jonathangomez9901
    @jonathangomez9901 3 роки тому

    How can I add more inputs after name?

  • @newborn7850
    @newborn7850 4 роки тому

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

  • @jaygurjar5915
    @jaygurjar5915 3 роки тому +1

    My apped row is not working

  • @wirot125
    @wirot125 3 роки тому

    Thank you very much.

  • @teruyaalmeida
    @teruyaalmeida 3 роки тому +1

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

  • @sistana
    @sistana 3 роки тому

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

  • @vijayshelar1857
    @vijayshelar1857 3 роки тому

    script function is not working how can i solve this

  • @tazulislam2698
    @tazulislam2698 3 роки тому

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

  • @littleclover2334
    @littleclover2334 3 роки тому

    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
      @DanielEscasa 2 роки тому

      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

  • @kenjichairilyuwono3912
    @kenjichairilyuwono3912 2 роки тому

    Add button doesn't work for me. Help

  • @newborn7850
    @newborn7850 4 роки тому

    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

  • @tongthokworld5466
    @tongthokworld5466 Рік тому

    Make a button for upload ducuments

  • @hengkiirawan239
    @hengkiirawan239 4 роки тому

    How to make button to go other sheet

    • @CodeWithCurt
      @CodeWithCurt  4 роки тому

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

    • @hengkiirawan239
      @hengkiirawan239 4 роки тому

      @@CodeWithCurt thanks

  • @NamHaVblog
    @NamHaVblog 4 роки тому

    thanks

  • @Mr_YaYa43
    @Mr_YaYa43 2 роки тому

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