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?
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?
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?
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?
My bad, Mike - you need parentheses around the math portion:
"PW" &
(10000 + {ID})
My bad, Mike - you need parentheses around the math portion:
"PW" &
(10000 + {ID})
Hi Jeremy,
It works perfectly - thank you so much for your help.
Mike