success! in here

been working on something for about a week. almost gave up this weekend and emailed a coworker’s husband.

but damn if i figured it out. made my brain hurt on friday.

got it done today.

basically, you enter data on a google form. it is recorded and then put onto a template. then it is turned into a pdf and emailed to people. the responses are saved on the response sheet and a copy of the document is saved as well.

next up is have the data get copied to a new sheet as well. this will allow a new trigger to run and create a new document once additional data is entered to create a workflow.