Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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 qauntity field of the first list minus the assigned quantity field and then set the result value to the first list qauntity field.

Is this possible? Thanks in advance

share|improve this question
    
can u please tell me in detail –  user23786 Feb 19 at 11:18
add comment

1 Answer 1

up vote 0 down vote accepted

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

share|improve this answer
    
THanks Dhaval. I did try that but i got error: Coercion Failed: Unable to transform the input lookup data into the requested type. –  naijacoder Feb 19 '13 at 0:41
    
when u compare look up value u have to set 'Return field as:' Lookup Value(as Text). It means u compare it with text value of lookup not by id. Hope u got it. –  Dhaval Kariya Feb 19 '13 at 5:12
    
please see my updated answer. –  Dhaval Kariya Feb 19 '13 at 5:21
    
Yes thanks.Figured it out myself yesterday.thanks alot –  naijacoder Feb 19 '13 at 20:24
    
gr8...you r most welcome.. –  Dhaval Kariya Feb 20 '13 at 6:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.