Conditional Statement on 3 fields?

Question

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!

wizgis · Answer

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

AdrianWelsh · Answer

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

AdrianWelsh · Answer

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