Workflow Question

[Lisa]

Hello,
I am using a workflow to assign a unique sequential number to a submitted
form. When the form is created, the workflow looks up a value on a different
list, then updates the form with the next value and increments the counter in
the list. This is work great in testing, however, I am concerned that in
production I may have two forms created at the same time, getting the same
number assigned. I can check out the form in the work flow and check it in,
but is it possible to check out the list item as well? Or is there another
way to handle it so two or more forms don't get the same number assignment?
Thanks

 

[Ed Thurber]

are you generating the number or are you using the list item ID as your
number?

i would recommend using the list item ID. this is sequential and is
assigned by SharePoint. In your list you can create the new list item
(maybe record the form name or some other identifying attribute) then get
the ID of that list item to use as the ID number for your form. this would
prevent the workflow from assigning duplicate numbers.

hope this helps

Ed

 

[Lisa]

Thank you. This is good advice and seems simpler that the direction I was
heading. I was using a single list item and incrementing after every new
form. I see how the list item ID is a better solution.