Automated emails from Google form

apps-script

#1

Hello,

I’ve set up the holiday tracking system and it works well so far. However, I’ve noticed that when a request is submitted via the form, the requester receives a confirmation email, but the person managing the spreadsheets doesn’t. Is there a way so the person approving the holidays also receives an email for the new request, so they know when they need to do something? I can’t find any relevant settings in the “Edit Form” section.


#2

@Nadia_Anag go to your Holiday Tracking master sheet. From the menu, do Tools > Script Editor.

Add a line as shown below. This should work!