2

I have 2 lists.

One list has a quantity field and the other list has assigned quantity field. When a user create or update a new item in the list with assigned quantity. I would like to do some workflow calculation by taking the quantity field of the first list minus the assigned quantity field and then set the result value to the first list quantity field.

Is this possible?

Waqas Sarwar MVP
  • 57,008
  • 17
  • 43
  • 79
naijacoder
  • 4,272
  • 26
  • 101
  • 188

1 Answers1

1

Yes u can perform this. If u know the basic spd list workflow then try this--- Whenever you are updating or using an item of some other list (on which the workflow is not running), then you need to have a column in that list whose value will match with the column of the item, on which the workflow is running. Now in your case, both the lists (list1 and list2) must have a common column value for each list item. This is required because you need to tell the workflow that out of several items on the other list, which item he should update. Therefore, for that you need to use a column of an item in the other list whose value equals any of the column value of the item on which the workflow is running. In short, for unique identification. By using this u can get value of list2(assigned quantity) and minus it from list1 (qauntity field) and save back it to list1.

enter image description here enter image description here

Hope it helps

Regards,

Dhaval

Dhaval Kariya
  • 336
  • 1
  • 2
  • 15