Hello all, I've already created a google script that will autofill a document when a form is submitted. However, I've run into a problem.
What I'm looking to do is create that document only if a particular question in the form response is a particular value.
For instance, the google form I've created is for creating work orders, but in this application, there is a high chance the work order will be opened and closed at the same time.
What I'm looking to do is create an option for the work order to be opened of closed. If the form option "open" is selected, I do not want the auto fill document to be created. If the form option "closed" is selected, I want the automation scripting to run.
If anyone has an idea of how to go about this or what lines of code to use that would be greatly appreciated!
Thanks!