I'm trying to create an attribute rule which would alert me of a duplicate value being entered in my dataset. The field I want to identify duplicates in is formatted as numeric and every expression I try I get an error expecting string values. I've been unsucessful at mofiying the code to work. Any Ideas?
Yes! There's a great Technical Support article here that describes the exact workflow to use. Good luck!
Part way there...There's a note on that workflow stating
Note: The attribute rule to identify duplicate field values in the attribute table only works for a text field.
The only work around I could find for a numeric field would be to create an additional field and setup a rule to calculate my numeric value over as text and then run that workflow. I rather not have a duplicate field but may have to go that route.
Ah - you're right! I did find an Esri Community post that uses Validation Rules for duplicates. You can read about it here.