Auto Increment on a selected set

LisaCasey

Hi All,

Our highway department likes to number their signs in order with an increment of one east to west/North to south.

The issue is that when a new sign is installed, it upsets the numbering. Users don't like to rely on me to re-number.

To re-number, I add the new sign, then re-number the remaining signs using a selected set and then field calculator in arc pro of field = field +1.

Does anyone know of a way I could create a way for the users to easily click a button to select the features that need to be re-numbered, and then calculate the field = field + 1 on the selected set? 

Right now users are using the edit widget in EXB.

Thank you!

Lisa

RPGIS

Sure thing. Here is a really basic rule that should give you some idea as to how that workflow would look like.

/*
There are multiple ways to write the same kind of arcade code
but here are a few examples that ultimately return the same result
*/

/*
defintiions:
	'<InsertCriteriaFieldname>': is the field name where you only that specific field determines the change
	'SomeValue': is the value that the criteria field is set to trigger the change
    '<InsertIncrementingFieldname>': the id field that has the incrementing id added
*/

// This gets the max value of the entire set of records in a featureclass/table
var M = Max( $featureset, '<InsertIncrementingFieldname>' )

// Option 1
var V = $feature.'<InsertIncrementingFieldname>'
IIF( $feature.'<InsertCriteriaFieldname>' == 'SomeValue', M+1, V )
	
// Option 2
IIF( $feature.'<InsertCriteriaFieldname>' == 'SomeValue', M+1, $feature.'<InsertIncrementingFieldname>' )
	
// Option 3
if( $feature.'<InsertCriteriaFieldname>' == 'SomeValue' ){ return M+1 }
else{ return }

Something else that I just remembered is that Survey123 surveys can also be added, which if you did not know, also uses the arcade functionality. This is similar to attribute rules with the only difference being that it can work on both hosted services and feature services. If you are primarily using a hosted service then this might be the best workflow, otherwise a feature service with attribute rules is better suited.

* Note: I have not played around too much with Survey123, but I have a lot of experience with arcade so this should hopefully get you in the right direction.

Another helpful resource is the arcade playground and the arcade resources.