topic Re: How to recreate a sequential field value using ObjectID value in ArcGIS Pro Questions

How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 14:29:04 GMT

I am trying to get an empty unique ID field populated. The field is CarteID. I want a prefix of SSP and use the ObjectID field. Example: ObjectID is 10234 - I want the CarteID to be SSP10234. Using Python 3, how do I use the field calculator to populate this field. What Expression do I use?

Then, going forward, is there a way to automatically populate this field when someone adds a new feature?

Thank you!

Re: How to recreate a sequential field value using ObjectID value

Anonymous User — Fri, 05 May 2023 14:52:15 GMT

The following should work in python:

"SSP" + !OBJECTID!

As for automatically populating the field moving forward I would suggest an attribute rule. Something like this should do the trick. The Insert Trigger ensures that the field is only calculated when a new feature is created.

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 15:05:56 GMT

I am new to Python. How do I put this in the field calculator? What expression do I use? When I put

"SSP" + !OBJECTID!

in the Code Block I get an error: 2 parameters are missing or invalid.

Thanks!

Re: How to recreate a sequential field value using ObjectID value

Anonymous User — Fri, 05 May 2023 15:18:04 GMT

Are you using arcmap or arcgis pro? Either way, when you open the attribute table right click on the field name (CarteID) click calculate field/Field Calculator and paste in the code. Make sure that the expression type/parser is python.

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 15:24:30 GMT

I am using Pro. I pasted the code and I get the error I mentioned above.

Re: How to recreate a sequential field value using ObjectID value

RhettZufelt — Fri, 05 May 2023 15:32:27 GMT

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 15:39:33 GMT

Re: How to recreate a sequential field value using ObjectID value

RhettZufelt — Fri, 05 May 2023 15:51:02 GMT

Working fine in 2.9.3 and 3.1.1.

It appears as if it doesn't like the first double quote in your syntax for some reason (perhaps copy/pasted in windoze). Try replacing or just use single quotes, they work as well.

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 17:50:02 GMT

What is the blue 1 you have at the beginning? I don't get that.

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 17:50:18 GMT

Mine is black...

Re: How to recreate a sequential field value using ObjectID value

RhettZufelt — Fri, 05 May 2023 18:08:40 GMT

That is the line number. Not sure why yours is black (or mine is blue), probably a windows setting.

you can turn that on/off with right click (in Code Block as well).

Did you get it to work?

Re: How to recreate a sequential field value using ObjectID value

RhettZufelt — Fri, 05 May 2023 18:14:15 GMT

OIC your issue now, yeah, that is a line number automatically inserted by Pro, NOT part of the code.

With line numbers off, should look more like this (with nothing in the Code Block section):

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 18:42:11 GMT

Yes! Finally got it to work. I had other issues with unregistered feature classes I had to fix first.

Re: How to recreate a sequential field value using ObjectID value

AndrewAidt2 — Fri, 05 May 2023 18:43:21 GMT

RhettZufelt Thank you!