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.
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?