Generating Unique IDs with Attribute Rules (NextSequenceValue)

3257
7
09-18-2020 03:20 PM
HusseinNasser2
Esri Contributor

Discover how easy it is to create a database sequence for new features in your database using a calculation attribute rule and the NextSequenceValue Arcade function.

Tags (1)
7 Replies
tempJeff_Kirchberg
New Contributor II

Am I the only one that the video doesn't show up for?

0 Kudos
HusseinNasser2
Esri Contributor

Hey Jeff can you view this ? https://www.youtube.com/watch?v=QPV_ydeoVY0

tempJeff_Kirchberg
New Contributor II

Yes.  Thank you so much!

0 Kudos
IvanKozoletov1
New Contributor III

Thanks for sharing this video Hussein,

we plan to use immediate attribute rule and NextSequence function to automatically set the bylaw enforcement Case # field to auto-populate with the next Case #. Example, 21-00001 would be the first record in year 2021, 21-00002 will be second and so on until the year changes to the next on December 31 then we need to re-set the counter to zero and update the year. Example 22-00001 for first record in 2022. Do you have any suggestions how to implement that? 

Thanks

0 Kudos
tigerwoulds
Occasional Contributor III

@HusseinNasser2 This is great, thank you! One issue I have to if a feature is deleted, the sequence number still continues. For example, I create 2 features, and ID is populated as 1 and 2 respectively. If I delete feature 2, I would like the next feature to have ID 2 rather than ID 3. Any ideas how to approach this problem? 

OrrGvili
New Contributor III

Hi 
how NextSequence  work with multiple versions SDE?  

0 Kudos
NickAddison
New Contributor III

Am I correct in thinking that AGOL does not support NextSequenceValue?

0 Kudos