topic Re: Conditional Statement on 3 fields? in ArcGIS Pro Questions

Conditional Statement on 3 fields?

DarleneP — Tue, 05 Aug 2025 18:26:59 GMT

Hi all,

I am creating a tree species database and 3 of the fields need to relate to each other.

The three fields will be: treecode, common_name, scientific_name- each with an assigned domain

How can I design this with the end goal being if any one of these fields are populated, the other two will auto-populate?

Thanks so much!

Re: Conditional Statement on 3 fields?

AdrianWelsh — Tue, 05 Aug 2025 18:30:24 GMT

I believe you can do with by using Attribute Rules in ArcGIS Pro.
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-attribute-rules.htm

You would use a Calculation Attribute Rule, looking for an insert or an update in one field, and then you would need to have some arcade script written out that is like a lookup table for what each field would mean to the other fields. So, it doesn't appear to be a straight forward process, but looks doable (and would be interesting to play with attribute rules as well!).

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/calculation-attribute-rules.htm

It looks like Esri has some documentation on writing the update/insert arcade expression here:
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-script-expression.htm#anchor15

Re: Conditional Statement on 3 fields?

AdrianWelsh — Tue, 05 Aug 2025 18:32:47 GMT

one thing I forgot to mention, I believe you need at least a Standard level license to create and manage the attribute rules (now called a Professional license).

Re: Conditional Statement on 3 fields?

wizgis — Thu, 07 Aug 2025 06:08:20 GMT

Hi @DarleneP

I believe you can use contingent values to achieve your objective. You can refer the following blog which highlights the use case : https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/contingent-values-in-arcgis-pro-2-4