AnsweredAssumed Answered

Incrementing Serial Number

Question asked by JulioSandoval on Dec 19, 2016
Latest reply on Dec 20, 2016 by JulioSandoval

So I forgot to turn on the feature to Serialize Records.

 

So I need to do it manually on the existing records and then have the auto-serial continue where I leave off.

 

But my loop script is not working for some reason.

 

I am starting with ID IL00006

 

My Script is as followed:

Go to First Record

Loop

If (not IsEmpty(table::tableID) )

Go To Next Record ; Exit After Last

     Else

          If (IsEmpty(table::tableID)

               Set Field (table::tableid ; table::tableID + 1

                   Go to next record ; exit after last

          end if

     end if

end loop

 

I have also tried it with setting the ID as a variable

Set Variable ($ID ; table::tableid + 1)

 

And I have also tried setting it like this as well:

"IL00006" + 1

 

The interesting thing is that the returned value is an 7.

Does not even return the IL000007 that I would expect.

 

Thanks guys. Pretty dumb mistake I know. And out of all the other tables, it was the only one that I missed.

 

Thank you all.

Outcomes