Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Stock updating

Topic Labels: Automations Base design Sync
Solved
Jump to Solution
1315 1
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