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


If (not IsEmpty(table::tableID) )

Go To Next Record ; Exit After Last


          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.