Stock updating

[elie]

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

[elie · Accepted solution]

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