Google Apps Script - Get and Set Values on Google Sheets

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

КОМЕНТАРІ • 26

  • @abhijitkumbhar1
    @abhijitkumbhar1 2 роки тому +3

    Best video I ever came across for someone starting to program in google sheets

  • @Gert-JanMStoop
    @Gert-JanMStoop 2 роки тому +1

    This is very helpfull. Very clear explanation. Thank you.

  • @leslievandyke5944
    @leslievandyke5944 10 місяців тому +1

    👍 You are the best! Please continue with more examples, etc. Thanks! 😍

  • @MatheusSilva-qm3ph
    @MatheusSilva-qm3ph 2 роки тому

    Another very good video, congratulations! A question, how do I create a new table tab with code? Thanks.

  • @danielaropermabry2210
    @danielaropermabry2210 2 роки тому +1

    You are the only one that I can follow without pulling my hair out. I am trying to do what you did in example 1 and 3 but with two sheets. Can you please help me! I have a drop down menu on sheet 'A' that I want my users to choose from but I wish to allow users to add another entry to the drop down. The drop down menu list is on sheet 'B' column H. So, from Sheet 'A' in cell H3 (with a submit button next to this cell), the user inputs into this cell, clicks the 'add' button, value inputted by user from H3 will then be copied to the last open cell in sheet 'B', column H... and then it will alphabetize and be in Caps lettering. I tried to record a macro for this and it does not work. :( PLEASE help me.

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

    I am looking for a code to create a simple RSVP form with google apps script and sheets. [ not using google forms ] Have you any advice for me?

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

    Hello Curt, I have liked your good videos. I have a question , how would I code a script to go through a data in one column get last row in that column and put data in cell below last cell with data. e.g. column A1 to A4 I have data then when I put data to any other cell but in column A , A6 down the Column A it is automatically pushed to A5.

  • @shivadhaker9024
    @shivadhaker9024 Рік тому +1

    Hy i think u can help me..
    I want to insert a number in a cell for one minute and for another minute it should be blank alternatively.
    Can u help me for this code..?

  • @JoshuaClancy12
    @JoshuaClancy12 Місяць тому

    What if I wanted to get all the cells with a particular value. Like, all cells where lastName="Smith"?

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

    Thank you. This helped a lot.

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

    Thank you very much for this video.

  • @DAVIDE-wr2iu
    @DAVIDE-wr2iu 2 роки тому

    Great Channel 😍

  • @wesleytheboss
    @wesleytheboss Рік тому +1

    how to copy data from "getCurrentCell()" and paste into another specific cell?

  • @098vanheartnet
    @098vanheartnet Рік тому

    Can you make a video tut on how to put pass a variable and set the value into a specific rows and colums that comes from the passing variable

  • @KopiPaste-zw1bb
    @KopiPaste-zw1bb 2 місяці тому

    Hullo! Thank you so much for explaining! I was wondering if there was a way you can explain appending data ? I made a script for a fake business that sells houses and I did it across 3 sheets. The script runs, and there’s nothing wrong with it I double checked the code and there’s no errors but it won’t append the information to the sheet I wanted it to go to. I was working well a few houses before I inputted a good amount of information into it but now it runs and all but it doesn’t pop up in the sales sheet. I hope this makes sense

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

    Could you do a video tutorial CRUD with datatables? Thanks a lot

  • @reunim8303
    @reunim8303 Місяць тому

    Sorry can we get from another sheet

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

    Hey Curt, you have dead link to this last blog page.

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

    Thanks

  • @DAVIDE-wr2iu
    @DAVIDE-wr2iu 2 роки тому

    Your web site is down? ☹

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

    THE FRUIT HAS SPOKEN

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

    Nice

  • @sureshatsasi
    @sureshatsasi 2 роки тому +1

    Sir webapp get and displayed for specific student images data from google sheet with HTML Page sir send me new videos sir

  • @April2023-fb6pf
    @April2023-fb6pf 9 місяців тому

    Whatis different with copy value ?

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

    Hi Curt Sir
    My Name Is Vikram
    Love Form INDIA
    Please Help me
    with how to comment or uncomment google sheet formulas by app script.
    please do this project if possible. 🙏🙏🙏🙏🙏🙏