I am working with Field Maps in ArcGIS Online and creating an expression on a form to populate a field with the next value. The issue I am having is trying to sort a field in a hosted feature layer descending that has a string format of ‘SS-20’.When I sort the field it returns ‘SS-9’ as the highest value instead of ‘SS-20’. I am trying to create an expression to take the highest value in a field and then calculate the next value when a new feature is added. The formula below works if there is a beginning value of ‘SS-1’ but will not work once it reaches ‘SS-10’. The result is ‘SS-9’. Is there a way to sort a string field which contains numbers as if it was a integer field?
var exist_assetID = $feature.AssetID
//Grab the highest number asset id
var streetsign = Top(OrderBy((FeatureSetByName($map, "Traffic Signs ", ['AssetID'], false)), 'AssetID DESC'), 1)
//(Result above is SS-9) Need it to be SS-20
//Calculate the last assetID + 1
for (var ss in streetsign)
var max_assetID = Number(Right(ss.AssetID, 1))+1
//Street Sign is tagged as SS-1
var new_assetID = Concatenate("SS-", max_assetID, '')
//If the unit id exists, pass the value. if not, pass the last value+1
iif(isEmpty($feature.AssetID), new_assetID, $feature.AssetID)
