I have 2 list, 1st have valie: ProductName, Price, Quantity. In second list i have Customer, ProductName(lookup with ProduceName from list1), and QuantityCustomerBuying. Now, how can i make workflow so every time someone insert value in QuantityCustomerBuying that value also show in Quantity from list one. Exemple, if i have in Quantity(list1) value 20, and someone enter in QuantityCustomerBuying(list2) value 20, how can i add that value to Quantity from list1 (20+20=40). Thanks in advance.
- Create a workflow that runs whenever an item in list 2 is created or updated.
- In this workflow, get the values of the quantity of the current item and the quantity of the corresponding Product from list 1.
- Add these values together.
- Update the value of the corresponding Product in List 1 with the new sum.