Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 05, 2022 11:48 PM
Hi, I’m having some trouble automating my stocklist levels.
I have set up automations that can pick up Qty Used of a certain product at a given time. I deduct that qty from the Initial stock I have inserted into my Airtable using a subtraction formula.
Now how do I replace Initial stock with this new reduced qty without having it go into an infinite loop? What kind of trigger can I use?
Jun 06, 2022 12:08 AM
Hi Niyatee, this is a bit difficult to answer without seeing how your data’s set up; could you provide screenshots of the relevant tables / fields perhaps?
Could you elaborate on why the infinite loop might happen? The automation that picks up the Qty Used
and deducts from the Initial Stock
field sounds fine, and I’m finding it hard to visualize why an infinite loop might occur
Jun 06, 2022 05:53 AM
Ona approach - create a data model where current “stock” is not tracked in a static field; rather it is simply a function of purchases and sales. The best record of stock levels is no record at all.