Stock count and Add/Substract values?

Hi there community! this is my first post here because i’ve never had any issue before, but i can’t seem to find the solution to the one i’m having right now…

I am creating a stock table that counts how many items i have for each product on my shop. The problem is that I don’t know how to make it so when, for example, i recive an order of 10 products.

What I would like to have is a column where I input a number and the stock count of the row’s correspondent product updates adding or removing the amount that I want, then the number that I typed gets cleared leaving the column blank.

I have tried some fixes for this, like multiple columns in order to make a sum between them, or a button that modifies the values, but nothing seems to work as I want, i’d be thankful if anyone could help me!

thanks in advance,
Gerard

1 Like

Hi
take a look at this:

https://coda.io/@tomas-sebes/pallets-stock

Tomas

1 Like

Thank you! I didn’t think of this way of solving the problem, really helpful!

1 Like

Really elegant! Love the logs as well.

2 Likes