Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 03, 2023 12:20 PM
Hi again,
I'm facing an issue in base designing and I can't find the answer myself or in this forum, so I'm trying here,
I have this field in the table named "Actions", linked to another table named "Inventory", every time I add an action, I can choose to add every item I have in my "Inventory" table.
I want to keep my inventory up to date, so every time I add a row in the "Action" table, I want to -1 of the specific item in my Inventory section.
Can you help me find a way to do it? I tried automations, but didn't really understand how that works, I tried formulas too, but I'm unsure of the results, given the fact that I can put various items in the Action table.
Thank you,
Elie
Solved! Go to Solution.
Dec 04, 2023 02:54 AM
Hi !
I finally achieved it !
In my table "Inventory", I added a Count row, to count every time the item was called in my "Action" table, then I did a basic "-" formula,
Have a great,
Elie
Dec 04, 2023 02:54 AM
Hi !
I finally achieved it !
In my table "Inventory", I added a Count row, to count every time the item was called in my "Action" table, then I did a basic "-" formula,
Have a great,
Elie