Generating Unique IDs with Attribute Rules (NextSequenceValue)

[HusseinNasser2]

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.

[tempJeff_Kirchberg]

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

[HusseinNasser2]

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

[tempJeff_Kirchberg]

Yes.  Thank you so much!

[IvanKozoletov1]

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

[OrrGvili]

Hi 
how NextSequence  work with multiple versions SDE?  

[NickAddison]

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

[JennaWalz3]

I have created an attribute rule that creates a Unique ID based on the next number in the database sequence. When a public user submits an entry through Survey 123 it will create this Unique ID. I have noticed that sometimes two entries will have duplicate Unique IDs. I thought it could be a time delay issue but the creation date/time is a few hours apart. Any ideas?

[OrrGvili]

there is chance they work offline and someone  didnt update his local Database or conection problem and the data sent layer  ? 

[JennaWalz3]

All users are required to work online. I am thinking it is a connection problem, but I have yet to pinpoint the cause.