I created a simple spreadsheet that takes form data and starts a timer on submittal (it is a service request). Once the request has been met, the respondent checks a "completed" check box and the timer is replaced with the time it took to respond and then timestamps the record. Here is my code:
if(e.value != "TRUE") return;
Now I want to send a notice to the submitter that says "Your request has been completed" when the respondent checks the completed check box. The form submits the users name and since I don't want them to have to enter their email every time with google forms "collect emails" function, I want to LOOKUP the email using the submitter's name.
I'd also like to return the text of the original request in the completion email.
I'm a newbie with Google Scripts so any help I can get would be much appreciated!