I want to create a field that would flag a row if its values don’t match its domains.
Is there a way to populate such a field using an Arcade calculation attribute rule?
- For each field, if the field has a domain, and if the value doesn’t match the domain, then set DOMAIN_VALUES_VALID to ‘INVALID’.
- Hopefully, the script could be dynamic, rather than needing to hardcode a list of fields with domains in the script.
I’m aware that it’s possible to prevent invalid rows in the first place using a constraint attribute rule. That’s a valid option. But I also want to experiment with a flag too. Thanks.
Edit: Unfortunately, I forgot to mention that the table has subtypes (with domains).