is there a way to do auto-enter serial to record

[solarpunk]

Hello,

i was wondering if this is possible. basically, i have around 17,000 records and i want to add auto-enter serial or id to those records already create it. is there a way to do it so that it will be cs-1 to cs-17000.

thanks,

victor

[andygaunt]

Hi -

Create your text field for your serial number.

Now, in browse mode click into that field and choose Replace from the Records menu. Choose the replace with serial number. Set the initial value to cs-1 and increment by one. Leave the check for update serial number in entry options.

HTH

[-Queue-]

Easiest way: move to a layout with the serial field on it, click into it and select the Records->Replace menu. Select 'Replace with serial numbers' and enter cs-1.

Safest way: create a script

Go to Record/Request/Page [First]

Set Field ["gID", "cs-1"]

Loop

Go to Next Field

If [ Status(CurrentError) = 301 ]

whatever you want to do if the record is in use...

Else

Set Field ["serial", "gID"]

Set Field ["gID", ""cs" & NumToText( TextToNum( gID ) - 1 )"]

End If

Go to Record/Request/Page [Exit after last, Next]

End Loop

[solarpunk]

Thanks you all.

I really appreciate your help.

thanks,

SolarPunk