Been doing a fair amount of searching but have not come up with quite the answer I’m hoping is out there.
I have a base with a couple tables to manage Inventory, ordering, receiving, etc. For now I’m mostly concerns with the ordering.
Table 1 is inventory, a list of items we have ordered and/or create a new line for when we add something new ie we have shovels, gloves, bolts, nails and if I were to place an order for some 2x4s, I could add the line
Table 2 is the Purchase Order list, with each PO getting a Unique ID that is the purchaser’s initials followed by an autonumber. This has a linked record to the vendors table and a multiple linked record field to the line item detail table. All POs are linked to one vendor and possibly lots of line items.
Table 3 is line item detail. This links line items to a particular PO and also links the inventory item to the line item (this allows we to order 100 nails 5 different times on 5 different POs and increase the inventory qty up to 500). All line items are linked to a single PO and a single inventory item (or a newly created item).
Table 4 is vendor info with name, contact, billing, etc.
I have figured out (pretty easily) how to build a very basic purchase order in page designer, but it seems to be limited when my purchase order gets to be many line items and needs to spill onto multiple pages (construction company, we often order 100+ items at a time depending on what it is).
I have watched a few videos on airtable + zapier + google docs which mostly center around capturing a single line item for an invoice or purchase order, but what I’d like to have is a dynamic length, multi line purchase order such that if I order 5 things, it’s just a 1-page doc. If I order 150 things, it might be 4 pages with the signature fields and such pushing all the way to the end. Then hoping to trigger the PDF creation and deposit that PDF back as the airtable attachment (saw how to do that too). Ultimately that whole process would be triggered by a button on the PO table #2 to execute creating the PO when it’s ready.
Building the table I’ve got, but connecting what amounts to multiple tables to a single page is where I’m losing it. I imagine there has to be a pretty solid example out there somewhere as this is a common scenario, but so far I have not found it. If anyone could point me in the right direction on what to configure in zapier to look at the PO record and pull data from all linked line item records (or a good example/sample/video/whatever), that would be much appreciated. The multi-line item is tripping me up.
Bonus points if anyone has any good rec’s for a way to have a native mobile app interface that could enter data for the POs (miniextensions seems to have what I need in web app form). Playing around with appsheet to see if that can serve the purpose.
Thanks in advance.