Running inventory
I have a table that tracks inventory at our locations. Every 2 weeks we measure and report the inventory so that every 2 weeks there is a new record for the inventory.
I'm trying to create a formul...
Forum Discussion
How are you creating the new inventory? Some kind of import or weekly process? You're not going to get around the recursion issue easily - your best solution is when you create the new inventory is to import/save the beginning inventory in the new record by copying the ending inventory from the prior.
------------------------------
Chayce Duncan
------------------------------
It's only a single numeric field. I could copy it, but in 2024 that seems like a lot of manual entry. This is a database not a spreadsheet.
------------------------------
Brian Hunot
------------------------------
You don't have to do it manually - you can automate the import or populate it during the creation when the inventory itself is created.
------------------------------
Chayce Duncan
------------------------------Hey Chayce I do have that already. I created a formula URL that takes the inventory to the parent table and then pushes it into a numeric field upon creation of the child record. However, if something changes, or there is a correction in the middle of the sequence, then all of the following records have to be manually updated.
------------------------------
Brian Hunot
------------------------------Understood - I'm suggesting however that you use Pipelines or some other import then to more / copy that data. So in your example - you could have a pipeline that searches hourly for any records that need to be updated, such as comparing the number you're expecting versus what is actually stored, and then have the pipeline update the value for you. You could run it daily if it doesn't need to run hourly or whatever cadence you need. The idea is you would automate the process that all or part of your button is currently doing and push the load to the Pipeline to make sure it stays in sync.
------------------------------
Chayce Duncan
------------------------------