Calculated Expression is missing the ability to add sequence numbers

373
0
01-28-2023 12:43 AM
cbp-geus
Occasional Contributor II

We have been trying to create a unique locality name when our field geologist are making a new feature point using the Calculated Expression in the ArcGIS Field Maps.

We have tried to combine the year of the feature creation with the user ID and and use either the OBJECTID or a sequence number from a created function in the geodatabase in  Concatenate Expression, but neither of these are working properly.

The sequence in the gdb is not available and the OBJECTID is not committed to the concatenate expression before it is created in the gdb which requires the feature point the be updated afterwards.

Here are the two calculated expressions:

//Create a unique concatenate Locality ID
var createuser = split(GetUser($layer).username,'_')
var createyear = Year(Now())
Concatenate(createyear, createuser[0], "Locality-",NextSequenceValue("LocalityNoSeq"))

or

//Create a unique concatenate Locality ID
var createuser = split(GetUser($layer).username,'_')
var createyear = Year(Now())

var oid = $feature.OBJECTID
Concatenate(createyear, createuser[0], "Locality-",oid))

Will there be an option to add sequence numbers to a Calculated Expression for the ArcGIS Field Maps in the future?

Christian Brogaard Pedersen
0 Replies