Calculating Unique IDs in fieldmaps

amandakwong — Wed, 12 Feb 2025 16:19:32 GMT

Hey everyone! I am trying to calculate a unique id for every test my field staff do out in the field. As we will have multiple crews in the field working offline I wanted to add the supervisors initials to it to keep the records unique. For some reason my code starts at 1-xy but then when put the next point down it jumps to 12-xy, and then every point after that remains at 12-xy for every point afterwards. If anyone has some insight into why its not calculating properly I would really appreciate it.

This is the code I have that is not calculating properly :

var numberlist = FeatureSetByName($map, "Subsurface Inspections")

var topnum = Top(OrderBy(numberlist,'OBJECTID'),1)

var counter = Number(Max(topnum,'OBJECTID'))

var id = counter + 1

var sup = $feature.Supervisor

return id + '-' + sup

Thanks!

Re: Calculating Unique IDs in fieldmaps

DougBrowning — Wed, 12 Feb 2025 16:58:20 GMT

Looks like topnumber you are not sorting in descending order with OrderBy

See here https://developers.arcgis.com/arcade/function-reference/featureset_functions/#orderby

in counter you are taking the max so I do not think you even need orderby really. But then you are adding onto objectid and not the actual count of records. This may be ok though since it would cover you on deletes.
this may work
var counter = Number(Max(numberlist,'OBJECTID'))

Also if the user does not take all the records offline this could fail on you. Overall we just gave up on numbering as we do not really need it anymore.

topic Calculating Unique IDs in fieldmaps in ArcGIS Field Maps Questions

Calculating Unique IDs in fieldmaps

Re: Calculating Unique IDs in fieldmaps