topic Re: Autopopulate a field in a feature class when created in Geoprocessing Questions

Autopopulate a field in a feature class when created

CraigPrisland1 — Fri, 22 Aug 2014 14:51:47 GMT

Hello all,

I have a question that I hope you can shed some light on for me. This is my scenario:

I have a point layer feature class (in a .mdb) with a field in it named ID_NAME. This field needs an unique value in it and cannot be a duplicate to any other existing features. I'm looking to see if there is anything that I can do to accomplish this task.

I attached a screenshot to better explain what I am talking about. As you can see, the "largest" value in this table is "PI.2014.314". What I am looking for is that the next point I manually add in would automatically insert "PI.2014.315" in this field without me having to type this in.

Any assistance would be greatly appreciated. Thanks in advance!

Re: Autopopulate a field in a feature class when created

mpboyle — Fri, 22 Aug 2014 15:05:07 GMT

Have you tried using the AttributeAssistant tools that Esri has? They can be found within the Water Utility Network Editing download found here. You will get a sample geodatabase and map document. We only use the Attribute Assistant add-in, which can be used to automate all kinds of editing tasks...not just utility data.

You will need to install the AttributeAssistant add-in and copy in the DynamicValue and GenerateId tables found within the sample geodatabase. Rules are built within the DynamicValue and GenerateId tables and there are examples within the downloaded data which you can use for reference, as well as the links below.

I think for what you're after, you'll want to read up on the GENERATE_ID method within the DynamicValue table.

Attribute Assistant rules: http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#//028s000000n6000000

Dynamic Value table: http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#//028s0000008z000000

Re: Autopopulate a field in a feature class when created

CraigPrisland1 — Mon, 25 Aug 2014 16:17:59 GMT

Great. Thanks for the information Matt. This is exactly what I needed.