The function SerialIncrement("IL0006"; 1) will give you "IL0007".
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
As to the structure of the script, I would write it (generically) like so:
Go to Record [ first ]
If [ not IsEmpty ( ... )
Set Field [ ... ]
# if you always write some value, save the If[ ] block and perform the conditional in the result calculation
Go to Record [ next ; exit after last ]
If you want to increment a string, use
SerialIncrement ( "someStringWithTrailingDigits" ; incrementor )
Instead of a script to re-serialize your IDs, try using Replace Field Contents with a calculation like
SerialIncrement ( "IL00006" ; Get ( RecordNumber ) )
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.
Odds things happen when you add numbers to strings ...
Thank you all for your help. Appreciate it!!