Select to view content in your preferred language

Automating Field Data in ArcMap

366
1
Jump to solution
06-13-2024 01:44 PM
CameronKoehler
New Contributor

I am trying to get a data field named "Site_NGUID" to automatically populate data.

The data to populate needs to have special text in front of and at the end of another field.

The example would be: 'SSAP' + (Object ID Field) + '@BC4011' = "Site_NGUID"

So the populated text should look like this: SSAP258@BC4011

 

When I try the field calculator query below, I get an error.  Also, is there a way to automate this field population for any new address points that are added?

Screenshot 2024-06-13 153545.png

0 Kudos
1 Solution

Accepted Solutions
RhettZufelt
MVP Notable Contributor

Close (need double quotes instead of single, and cast the numeric OID to string).  This is working for me:

 

"SSAP" + str( !OBJECTID! ) + "@BC4011"

 

RhettZufelt_0-1718315913327.png

To 'automagically' populate the fields, look into Attribute Assistant Expression function.

R_

View solution in original post

0 Kudos
1 Reply
RhettZufelt
MVP Notable Contributor

Close (need double quotes instead of single, and cast the numeric OID to string).  This is working for me:

 

"SSAP" + str( !OBJECTID! ) + "@BC4011"

 

RhettZufelt_0-1718315913327.png

To 'automagically' populate the fields, look into Attribute Assistant Expression function.

R_

0 Kudos