Community
Select to view content in your preferred language

Auto Increment ID Field for ArcGIS Collector with customized behavior

12226
31
03-24-2017 03:31 PM
Status: Open
AntonSizo_
by
Occasional Contributor

It would be nice to have  auto Increment ID fields for ArcGIS Collector with customized behavior. For example, I need a filed which will automatically generate a unique ID for a new sample taken based on some rules, e.g. <Year><Surveyor Initials><Code Word><Int number>.

Tags (2)
31 Comments
bsanders69
by
‎07-18-2022 09:10 AM

I created a Sequence in SQL Server and a simple attribute rule to retrieve the next number from the sequence (expression: Return NextSequenceValue ("SEQ_SIGNPOLES_UID")) and set the Insert Trigger to true.  Rules inside a dataset disables the entire dataset as non-functional in ArcMap, so this is not an option in 32 bit world. Hope this helps someone.