Now that Google Business has conditional notifications, can this be implemented easier without the script, but still using specifics from the dropdown menus?
So the conditional notifications that Google implemented for the business accounts can make simple notifications easier, but it doesn't give you any customization on what gets included in the notification or how it's formatted. You can see a quick walkthrough of how to set up Google's notifications here: support.google.com/docs/thread/278360807/google-sheets-new-feature-conditional-notifications?hl=en
E is the event object so when you use the native onEdit(e) function or something else like checkMySheet(e) and add a trigger, the event object is what contains some information about the edit, for example, the cell that got updated, the sheet, etc. When you authorize the script, it's normal to have that error because the script is expecting 'e' to contain some things but when you run it in the script editor, it won't.
It's Tooooooooooooo awesome, it solves my problem now.
Awesome, so glad this video was helpful for you!
This video just saved me alot of stress.. Thank you.. I have liked and subscribed😊
Awesome! Thank you!
On my sheet, we have hidden columns. Would you count the hidden columns in the array?
Very cool video, this is exactly what we were looking for.
Yes, you would need to count the hidden columns as well.
This is great! What do I need to remove if I don't want any data from the columns pulling into the email, just the notification email sent?
You can just type what you want in the htmlBody part of the sendEmail section, and don't need to include any of the template literals: ${}
Now that Google Business has conditional notifications, can this be implemented easier without the script, but still using specifics from the dropdown menus?
So the conditional notifications that Google implemented for the business accounts can make simple notifications easier, but it doesn't give you any customization on what gets included in the notification or how it's formatted. You can see a quick walkthrough of how to set up Google's notifications here: support.google.com/docs/thread/278360807/google-sheets-new-feature-conditional-notifications?hl=en
checkMySheet(e) - what "e" mean? tried to apply to my sheet but there's an error in e.range?
E is the event object so when you use the native onEdit(e) function or something else like checkMySheet(e) and add a trigger, the event object is what contains some information about the edit, for example, the cell that got updated, the sheet, etc. When you authorize the script, it's normal to have that error because the script is expecting 'e' to contain some things but when you run it in the script editor, it won't.