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?