Hi everyone, I have previously built a system to manage our sales orders by using a custom form and a helper table to take care of the order/line item creation. It works really well and now I will add a system for handling Purchase Orders as well. This time, I don’t need all the custom functionality that comes with a Custom Form, so i was hoping to use the Glide standard forms to save on the number Edit updates needed.
For some reason I can not figure out how to build it in a way that would work. What I need is a way to create a new Purchase Order and then be able to add different line items to this order and also set the qty for each of them. How would you build something like this without using a custom form and helper tables?
I am thinking I can set a UUID in a column in the user table when I click “Create new purchase order”, then open the Form screen. I would use this then UUID to build relations between orders and Line items. But how would I set up the Form Screens? Do I need to create an order before trying to add Line items? Or can I just add a custom collection to the Order Form screen with a “Add new” button that would add the Line items to the Order, and then the Order is created when I click “Submit” on the Form screen?
Sorry, for the confusion Does anyone understand what I am trying to do and could someone please point me in the right direction or give some general idea on how you usually build similar processes?
Thank you very much for your help