I have a sde feature class of different sites around the city that editors will use to create new ones created through an application. I am hoping that there is a way to when the editor goes into the app to create a new site, as the form pops up to begin editing- the site ID (unique ID for each site) will be automatically populated with the next number in sequence (last one created was site .00001 and the next one will be .00002 and so on). This will help with making sure that a unique ID isn't used twice and the editors don't have to remember the last one they used.
Thanks!
But they need a working system more, right?
Well right now, I have a SQL script in my application that runs a query on the last record found and displays it for them- it's a band-aid on this problem right now, but I tired convincing them about the ObjectID but they need it to be that string of numbers
Would the concept of NextSequenceValue of Attribute Rules (ArcPro) in this thread work for you?
This looks cool, but I am using arcmap to publish services from our local servers.
Maybe this is another option?
https://community.esri.com/thread/182383-auto-generate-sequential-asset-ids
Andres:
It looks like you might be able to use the Auto-Increment solution once ArcPro can publish services directly to ArcGIS Server without too many bugs once it is hopefully released by ESRI in first half of 2019:
https://community.esri.com/ideas/12258
You might want to vote up this idea if you have not already done so.