MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Create Unique ID column in a list

  Asked By: Reuben    Date: Sep 28    Category: MOSS    Views: 2534

This is related to my previous issue with a workflow problem.

Microsoft will let you update an item in a list as long as the ID in both lists
matches. There may not be an instance where these two columns match however. I
need a way that I can either change the ID of an item in a list, or create a new
ID column that I can reference in a workflow.

Here's the catch. I do not have VS2005, so this would all need to be through
either the web interface, or through SPD.

It is a MOSS2007 setup.



4 Answers Found

Answer #1    Answered By: Gail Richmond     Answered On: Sep 28

Maybe I'm missing part of this, but can't you just create  the column  you
want on both lists and populate that with whatever data you need to identify
the elements, then in the workflow  call that data?

Answer #2    Answered By: Ramona Solis     Answered On: Sep 28

You would think, and I have already tried this route, but my workflow  errored
out saying that it couldn't find the list  item to update. (I guess it didn't
look hard enough.)

Answer #3    Answered By: Harvey Blankenship     Answered On: Sep 28

we do this all the time. BUT, the item(field,column)((hate this SP
vocabulary))is always a copy(via WF step) of a SP generated ID. Maybe these
are long  ints or some special type?

Answer #4    Answered By: Xiomara Blanchard     Answered On: Sep 28

Well, I found two solutions to the problem  I was having. One was being able to
identify the workflow  Item ID, and that is what I was looking for. In case that
doesn't work, there is a feature on codeplex that will allow a column  to require
unique input. Although SPD would bark and scream about not returning single
results, etc. This could work also, depending on the information that you
assign. The documentation for SPD is spotty, and makes it difficult to find the
exact information you are looking for, but I got the issue  resolved. Thank you
to the group for the help. (I couldn't do my job without you guys.)

Didn't find what you were looking for? Find more on Create Unique ID column in a list Or get search suggestion and latest updates.