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
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.
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.
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.
Great tutorial, thank you. Just a short note: the break statement must be moved into the if{} block.
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
Can you use Onedit trigger on forms to make a copy of an existing spreadsheet template with the titled renamed by form entry value?
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.
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.
Somehow when i type in the exact same stuff it only gives me the possibility to create time driven triggers, I'm really confused :/
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.
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.
hey whats your email i need help with certain triggers,please.
+J.Cleveland Greene The Second hey. Check out my website jordanrhea.com or my subreddit Reddit.com/r/teacherscancode
Grat tutorial !
Nice tutorial, however "condition ? true : false" might be the most useless thing iv ever seen XD