Hopefully this should be fairly straight forward. I need a field to be a unique number for each new item added to a list. I need it to start from 1000. I've set up two variables:

number_variable

number_variable_plus_one

I've set the number variable default to 1000. Then I've got a Math Operation with Plus Value 1 and store result in

number_variable_plus_one.

All that it's returning is 1001 with every new item. I know I'm missing something obvious?

Any help appreciated.

Hi Darren,

I think you have got the pattern right, may be I didnt understand your statement "

o setting number_variable to the ID number?"Will describe in a little bit more detail..

1) Create 2 variables

i) Initial Offset - Integer - Default value = 1000

ii) Number_variable_plus_1000 - Integer

You don't require plus 1 as we can depend on the identity column to give you unique number.

2) Add the Math function

3) Update the list item

Where ReferenceID could be your column on the listitem.

regards,

Shrini