@DianeBaker @AdamHart1
This Arcade expression below can be used in a popup to find the next value in a 'Book' and 'Page'. (right click on the layer, configure popup, add an expression...)
// Expression uses the 'Book' and 'Page' fields to find the maximal parcel name in the given 'Book' and 'Page'
// then returns the value + increment
var ParcelsFS = FeatureSetByName($map, 'Parcels_CREST', ["Name", "Book", "Page"], true);
var book = $feature.Book;
var page = $feature.Page;
var MaxParcelNumber;
// Find the maximal parcel number in a given book and page
if ((!IsEmpty(book))|| (!IsEmpty(page))) {
var sql = "BOOK = '" + text(book) + "' AND PAGE = '" + text(page) + "'";
var FilteredParcels = Filter(ParcelsFS, sql);
MaxParcelNumber = Max(FilteredParcels,"Name");
//Increment
var increment = 1; // change to your increment size
If (!IsEmpty(MaxParcelNumber)){
MaxParcelNumber = text(number(MaxParcelNumber) + increment);
return MaxParcelNumber;
}
}
It assumes you have a 'Book' and 'Page' fields on the parcels layer.
I was about to turn this into an Attribute Rule when I realized that if you create a new parcel, you are unlikely to have the Book and Page fields populated... so when creating a new parcel, the expression will need to intersect with another layer to get the Book and Page values.
Before creating the Attribute Rule:
- Do you have a feature class for the Book and Page?
- Is this a valid path forward?
