Dear all, first sorry for my bad english
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.