Is there a way to auto sum multiple fields in the same record?

767
1
11-04-2016 01:13 PM
MatthewKalcich
Occasional Contributor

Example: A field crew is assessing an attribute...... they enter values in fields A, B, C, and D is there a way to auto sum them in Field E? The sum would be a number that meets a threshold. If that threshold is exceeded than an action would need to be taken. I am looking for a way to automate this during collection in the field so they don't have to use math. Is there a way to perform a mathematical calculation as a default for a field value?

Thanks, Matt

0 Kudos
1 Reply
BlakeTerhune
MVP Regular Contributor

If you're in an enterprise geodatabase, a database trigger could do that for you but those aren't super fun. If the field crew is using ArcGIS Desktop, you could look into Attribute Assistant. If it didn't need to be done immediately, you could create a Python script that runs on a schedule to update that field.

0 Kudos