topic Re: Attribute Rule - Sequential Number in a Text Field in ArcGIS Pro Questions

Attribute Rule - Sequential Number in a Text Field

avonmoos — Wed, 27 Dec 2023 16:25:22 GMT

I've created a attribute rule to give every new feature a custom ID, the first part of the ID is 1234AB and the next part needs to be a 4 digit sequential number starting with 0001 (1234AB0001). I have a history feature I need it to reference for duplicates, so if the custom ID field in the history feature already has ID 1234AB0001 then the rule would automatically bump up 1 number and assigned 1234AB0002. Any ideas on how to accomplish this?

Re: Attribute Rule - Sequential Number in a Text Field

Raul — Wed, 27 Dec 2023 18:12:44 GMT

You need to query the historic featureclass to obtain the last id, you can do so by referencing the FC using FeatureSetByName

Then you can get the last id from that featureclass using a combination of First(), OrderBy(), and Filter()

Once you obtain the last ID, add +1 and perform your concatenation.

Re: Attribute Rule - Sequential Number in a Text Field

RhettZufelt — Wed, 27 Dec 2023 21:59:41 GMT

Here is an attribute rule that I use for that:

if(isempty($feature.ID) && $feature.Layer == "ST-DYCL"){ var vals = FeatureSetByName($datastore,"PW_Pro.DBO.Striping",['ID','LENGTH_FT'],false) var DYCLvals = Filter(vals, "ID LIKE 'DYCL%'") var numarray = [] for (var n in DYCLvals){ var nn = Number(Replace(n.ID, 'DYCL','')) Push(numarray, nn) } var maxnum = Max(numarray) var maxtext = Concatenate('DYCL',(Text(maxnum + 1, '00000'))) return maxtext }

My ID field for this data starts with "DYCL", so this filters for all values that start with that, strips(Replace) the DYCL from it and converts to a number, finds the max value, concatenates that back with the DYCL with incremented number and returns it.

Re: Attribute Rule - Sequential Number in a Text Field

avonmoos — Fri, 29 Dec 2023 16:36:07 GMT

I'll give this a try Rhett! I should have just gave you a call on this. Thanks!