Waffle Bytes

I was asked to create a script that would send an approval email once a request was approved - for 2 separate groups, and to be used for 2 different reasons!  The example below is being used for building access approval (RE: the work-at-home requirements due to COVID-19).  The other way this was used was for approval of spending requests.  These utilize an additional column that is marked (in these cases) with a Yes that will trigger the email, then if an email is sent it makes that notation in the final column.  Note - the script will break (stop running) if someone submits a non-working email from a form, so I recommend having the form auto-collect the email. Here are the directions for using the script -  Creating and Sending the Email 1. Create the spreadsheet  You can either do this with a New Spreadsheet, adding the data fields you want  OR Create a form with the data you are collecting and have it create the companion spreadsheet Important :...