Create a Google Form as a inner organization Purchase Order with input box options fed from a Google sheet. I will supply the form and sample Google Sheet. The google Sheet will have multiple worksheets that are named corresponding to the combo box it fills.
I need the combo box to lookup the data in that worksheet. That data might change periodically, so the lookup needs to be dynamic. Do not restrict to the list, If the desired item isnt in the list, they can put in what ever they want into that box.
There needs to be a command button to "Send Form" automatically to an email address specified in the google sheet "Setup" page. Can that data be formatted to an existing Google Doc and emailed or just a notification that there is something new?
If possible, can each item data of the form after sending the email, be written to a single line back to the google sheet in a sheet call "Processed PO's" . I would like to hear ideas on how to implement this or better ideas to make this happen.
Thanks in advance