topic Re: how to create a correlative, based on a start number (script field calculator) in Python Questions

how to create a correlative, based on a start number (script field calculator)

RTMRTM — Mon, 18 May 2020 22:55:36 GMT

I try to create a script, which generates a correlative number (ID)
the start number can vary,
will not start from 1 or 0
it can be any number start and the number of rows can also change

done this example but it didn't work

rec=0
def autoIncrement():
    global rec
    pStart = 11 #adjust start value, if req'd
    pInterval = 5 #adjust interval value, if req'd
    if (rec == 0):
        rec = pStart
    else:
        rec = rec + pInterval
    return rec

expression
autoIncrement(ID)

expected result------------

(sorry my bad English)Thank

Re: how to create a correlative, based on a start number (script field calculator)

DanPatterson — Mon, 18 May 2020 23:43:19 GMT

replace accented characters with the field calculator not closed, you should close old threads if they were answered

/blogs/dan_patterson/2016/08/14/script-formatting for code formatting so that line numbers can be referenced

What result did you get? You only posted what you got.

Re: how to create a correlative, based on a start number (script field calculator)

DavidPike — Tue, 19 May 2020 07:37:30 GMT

You're passing 'ID' into 'def autoIncrement():' - which has no input parameters.

expression
autoIncrement()

Re: how to create a correlative, based on a start number (script field calculator)

DanPatterson — Tue, 19 May 2020 08:57:10 GMT

Just use the field calculator rather than running the script... or copy and edit it exactly

Re: how to create a correlative, based on a start number (script field calculator)

JoeBorgione — Tue, 19 May 2020 14:17:45 GMT

Create Database Sequence—Data Management toolbox | Documentation