Form inputs data to sheet, create a trigger to use some data to create a form?
Question is a bit vague in the subject. I do hope it is enough for others to search in the case this is possible or even answered.
Scenario: Working on a procurement request process. Users put in a request, based off an item sheet (budget with items listed). Once a specific item number is selected, currently it will populate all the necessary data from the budget sheet over to the requested procurement sheet.
From there, I am attempting to figure a way to create an approval process. First, the users manager must see this request (via form??) and approve or disapprove, then finance if approved, and so on (this process I have figured out with the GREAT help of this site). Can a form be created and sent out for approval? Thoughts? Once approved by one stage, will need to re-create this process for finance.
LASTLY: Again, a form created based off a few inputs from other forms, create basically a mock-up Purchase Order (Form/Report) that can be emailed out to users to complete the purchase process?
I have gone thru some of the templates looking for maybe a bit of a guide to help my brain kick in with an idea, but I have basically already covered alot of what those cover, and some. It is alot of work, but when it is complete, it will be extremely helpful with the workflow and process.
Thoughts or ideas? Anything is possible if coded correctly.
Help Article Resources
Check out the Formula Handbook template!