Apps Script: Installable Triggers

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

КОМЕНТАРІ • 12

  • @filippobalestrini7571
    @filippobalestrini7571 7 років тому +2

    Great tutorial, thank you. Just a short note: the break statement must be moved into the if{} block.

  • @fab99fab
    @fab99fab 7 років тому

    Hi jordan, on trigger i have some what similar question. I have a script for which i would like to create a specefic time trigger which should run every day at 4pm and 9pm except on fridays. To perform this task i do it manually for a whole week . Is there a way we can schedule trigger by script ? Appreciate ur help

  • @Kwikwins_shopowls
    @Kwikwins_shopowls 5 років тому

    Can you use Onedit trigger on forms to make a copy of an existing spreadsheet template with the titled renamed by form entry value?

  • @ash1506379
    @ash1506379 5 років тому

    Hi Jordan, I'm using on submit trigger for Google form. Problem is it's running multiple times. Can you suggest something for that?? Thanks.

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

    You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these raws for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.

  • @waveboardstyler
    @waveboardstyler 6 років тому

    Somehow when i type in the exact same stuff it only gives me the possibility to create time driven triggers, I'm really confused :/

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

      I'm too years behind on this answer but i think that problem is because you didnt link your spreadsheet to the code, if u open apps script editor from the browser and not from an already opened sheet there will be no link between them yet so that might be the reason you can only get time driven triggers. This probably wont help you but it might help the next guy who sees this comment.

  • @Str8TalkNoDiddy
    @Str8TalkNoDiddy 7 років тому

    How to add individual time-driven triggers to each of my sheets? docs.google.com/spreadsheets/d/1kxQGgDCgFsZuI67yVqzWBtM57qQuAJh66it6XQbiQO4/edit?usp=sharing ...... I had it working fine and then I added the Asset sheet started the problem.

  • @jcgtwo
    @jcgtwo 6 років тому +1

    hey whats your email i need help with certain triggers,please.

    • @JordanRhea
      @JordanRhea  6 років тому

      +J.Cleveland Greene The Second hey. Check out my website jordanrhea.com or my subreddit Reddit.com/r/teacherscancode

  • @mamanforshivuk2899
    @mamanforshivuk2899 6 років тому

    Grat tutorial !

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

    Nice tutorial, however "condition ? true : false" might be the most useless thing iv ever seen XD