I have 3 tables.
Tracking Number
Invoice
Purchase
Tracking Number - Generates a unique number (I understand all of the issues with sequentail numbers) and is my โMaster Tableโ, the one ring to rule them all.
Column structure is as follows:
Invoice - Itโs pretty much what it sounds like. It references back to โTracking Numberโ and does some math
Column structure is as follows:
Purchase - It records purchase data. It references back to โTracking Numberโ, โInvoiceโ and does some math.
Column structure is as follows:
Hereโs what I am looking to achieve. I would like to be able to have the users go into an invoice hit save and have a basic frame work. From there I would like users to be able go back into the invoice (easy and done).
I would like to be able to have both a โRelated PURCHASEsโ, but also I would like to be able to have a โAll Purchases with Related TRACKING NUMBERโ.
My plan is that they could use the โAll Purchases with Related TRACKING NUMBERโ to click on an item on that list and open each item that they actually used. Then update the โINVOICE KEY IDโ for that item to reflect the invoice that it should appear on. Then when the user hits save it pops them back to the โInvoiceโ they were in. The โRelated PURCHASEsโ would then list what was actually used for that invoice
I hope that makes sense.
I have been fiddling around all morning with virtual columns and Select() / Filter() statements. I canโt get anything to provide links like REF_ROWS() does.
Solved! Go to Solution.
I embrace the darkness of sequential numbers, was born in it! (not an issue at all, and my app(s) have multiple users)
But back to the actual issueโฆ
I think I have found my solution: School Model - AppSheet
From this thread: Help with many-to-many reference and bridge table - #19 by TyAlevizos
Basically it involves having a 4th sheet to act as a master library.
I am just in the process of testing it for my own needs, but it looks very promising.
I embrace the darkness of sequential numbers, was born in it! (not an issue at all, and my app(s) have multiple users)
But back to the actual issueโฆ
I think I have found my solution: School Model - AppSheet
From this thread: Help with many-to-many reference and bridge table - #19 by TyAlevizos
Basically it involves having a 4th sheet to act as a master library.
I am just in the process of testing it for my own needs, but it looks very promising.
It works!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |