Our company currently uses Forms to submit and approve Purchase Orders/Requisitions. Out internal purchasing rules limits the submitter to a single vendor (multiple items using a collection) and manager and/or senior manager for approval.
Is it possible to build a single form that would allow a user to submit one purchasing form with multiple vendors with multiple items per vendor to different managers?
For example:
Vendor A
- one or more items for vendor A
- Manager A approval
Vendor B
- one or more items for vendor B
- Manager B approval
+ Add (add as many vendors and managers as needed)
On submission, use a Workflow's Invoke Business Process to gather each Vendor iteration and send a forms link to the manager specified for approval.
If I could have a table with repeating rows within a repeating collection, I could make this work. I know this is currently not an available feature. I can't seem to come up with a plan to accomplish what I want using the tools available in Forms.
At the end of the day, having the user submit multiple forms as we do now is not a show stopper but if anyone has any thoughts on how to accomplish please let me know.