Append a Range of Cell Values to a new Google Sheet Tab with Apps Script

แชร์
ฝัง
  • เผยแพร่เมื่อ 19 ม.ค. 2025

ความคิดเห็น • 8

  • @simonwilson9610
    @simonwilson9610 13 วันที่ผ่านมา

    I really like your tutorial style, clear and easy to understand. My problem is I can't type fast enough. Is it possible to download copy of the final script? I learn from reading others scripts.

    • @yagisanatode
      @yagisanatode  12 วันที่ผ่านมา

      Thanks for the kind words, Simon. The spacebar for pausing is your friend in this case. It will let you read the script and catch up when needed. This is what I do when following along my favorite tutorial websites. I know if I write the script myself that I will have a greater understanding of the code and, hopefully (I'm serious here), make some mistakes, so I can learn how to troubleshoot specific problems related to what I am learning.
      Happy Coding!

  • @Redsonja77
    @Redsonja77 5 หลายเดือนก่อน +1

    Thank you for sharing this!! I'm gonna check the other videos too! I might have a use for those but I still don't know how could I adapt it for my google sheets... I'll try to play with those codes 😆

    • @yagisanatode
      @yagisanatode  5 หลายเดือนก่อน +1

      No problem. Enjoy.

  • @AndrewRMoloCPA
    @AndrewRMoloCPA 2 หลายเดือนก่อน

    Thanks for Sharing! only problem is the script takes more than a minute to run. any solutions to this?

    • @yagisanatode
      @yagisanatode  หลายเดือนก่อน

      That depends on the type and size of data you are appending and how you are retrieving the data.

    • @AndrewRMoloCPA
      @AndrewRMoloCPA หลายเดือนก่อน +1

      @@yagisanatode Thank you so much. all I had to do was remove all formatting from the source and destination sheets and it went down to 4 seconds!

    • @yagisanatode
      @yagisanatode  หลายเดือนก่อน

      Great to hear.