Auto Increment ID Field for ArcGIS Collector with customized behavior

[AntonSizo_]

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

[bsanders69]

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.