Set the values of some colums in this row for decrease stock itens

Dear all, first sorry for my bad english :sweat_smile:

I am developing an APP to control my sales and rentals activities, and to be able to decrease either rented or sold products from stock, I am using a sheet called “Base de Produtos”, and have inserted a virtual column that brings product code from sheet “Vendas” to the sheet “Base de Produtos”.

To make this ACTION I have used “set the values of some colums in this row for decrease stock itens” triggered by a Workflow activity as follows.

ACTION: Decrease 1 unit if the Product 1 code is the same of product code on stock

WORKFLOW: Every new Add, if the Product 1 is not empty

The idea is quite simple, If I have sold a product on sheet “Vendas”, I want to decrease the stock on sheet “Base de Produtos”, but it is not working.

I habe tried to find some similar answer, but didn’t suceed.

Thanks a lot for your support.

Gustavo Secco

Just succeed using “Filter” and a new action between decrease and the workflow. Thanks =)

1 Like