Extracting Google Sheets IDs with Google Apps Script

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

КОМЕНТАРІ • 9

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

    This actually worked! Since this only extracted the IDs, I used JOIN function as you explained in your "combine multiple spreadsheets into one" video to merge the initial URL and '/edit#gid=0' with the ID. You saved the day!

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

    Woah! Thank you so much for picking up my comment and making a whole video on it. This is going to save so much of my time! Thanks again man!🔥🔥

  • @dee-us420doc
    @dee-us420doc 7 місяців тому

    Thank you so much for the explanation. I am a OG programmer and this helped me tons!

    • @HashAliNZ
      @HashAliNZ  7 місяців тому

      You're very welcome!

  • @malikastar9265
    @malikastar9265 9 місяців тому

    Thank you so much, I still have no clue with google sheets scripts, but I use the ones already done when I need them, I suppose this function will extract the sheets IDs in the same order they are in the spreadsheet.

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

    Hello sir. Is there any way to personally discuss with you? I have some problems regarding my spreadsheet and qr code creating and i cant seem to successfully create it. I watched your videos and try to combine what i learned but i am kinda lost midway through. Please help me.

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

      Sure, send me an email at themathlabnz@gmail.com with a viewable or editable link to your spreadsheet and Google form

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

      @@HashAliNZ thank you so much sir! I really appreciate it and i will send you the documents.