Help

Re: Stock updating

Solved
Jump to Solution
1019 0
cancel
Showing results for 
Search instead for 
Did you mean: 
elie
5 - Automation Enthusiast
5 - Automation Enthusiast

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,

elie_0-1701628094972.png

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

 

1 Solution

Accepted Solutions
elie
5 - Automation Enthusiast
5 - Automation Enthusiast

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

 

See Solution in Thread

1 Reply 1
elie
5 - Automation Enthusiast
5 - Automation Enthusiast

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