Autonumber formula in primary field

[Mike_Ashton]

Hi,

I would like my primary field to be autonumbered, starting with “PW10001”, then +1 value to each new record (so PW0002, PW0003, etc). I think I need a hidden Autonumber column to give me each new sequential number, but I’m stuck on how to string the formula together in the primary field to bolt the “PW10000” to that.

Can anyone help?

[Jeremy_Oglesby]

Hi @Mike_Ashton,

You do need an Autonumber field, and then in your Primary field you’ll need a formula like this:

"PW" & 
 10000 + {Autonumber Field}

Once you hit 10,000 records created in this manner, the result is going to be:
“PW20000”

Is that what you want? Is 10k records an issue?

[Mike_Ashton]

Jeremy_Oglesby:

"PW" & 
 10000 + {Autonumber Field}

Hi Jeremy,

Thank you so much for this. 10k records is fine, thanks. I have copied and pasted exactly, then changed {Autonumber Field} to the col. name, which is “ID”, the column gives “NaN” all the way down. I have tried with and without curly brackets, so

“PW” &
10000 + ID

and

“PW” &
10000 + {ID}

same result both ways?

[Jeremy_Oglesby]

My bad, Mike - you need parentheses around the math portion:

"PW" &
(10000 + {ID})

[Mike_Ashton]

Hi Jeremy,

It works perfectly - thank you so much for your help. :blush:

Mike