topic Is there a way to auto sum multiple fields in the same record? in Data Management Questions https://community.esri.com/t5/data-management-questions/is-there-a-way-to-auto-sum-multiple-fields-in-the/m-p/728634#M41268 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>Thanks, Matt</P></BODY></HTML> Fri, 04 Nov 2016 20:13:21 GMT MatthewKalcich 2016-11-04T20:13:21Z Is there a way to auto sum multiple fields in the same record? https://community.esri.com/t5/data-management-questions/is-there-a-way-to-auto-sum-multiple-fields-in-the/m-p/728634#M41268 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>Thanks, Matt</P></BODY></HTML> Fri, 04 Nov 2016 20:13:21 GMT https://community.esri.com/t5/data-management-questions/is-there-a-way-to-auto-sum-multiple-fields-in-the/m-p/728634#M41268 MatthewKalcich 2016-11-04T20:13:21Z Re: Is there a way to auto sum multiple fields in the same record? https://community.esri.com/t5/data-management-questions/is-there-a-way-to-auto-sum-multiple-fields-in-the/m-p/728635#M41269 <HTML><HEAD></HEAD><BODY><P>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 <A href="http://solutions.arcgis.com/shared/help/attribute-assistant/">Attribute Assistant</A>. If it didn't need to be done immediately, you could create a Python script that runs on a schedule to update that field.</P></BODY></HTML> Fri, 04 Nov 2016 21:53:08 GMT https://community.esri.com/t5/data-management-questions/is-there-a-way-to-auto-sum-multiple-fields-in-the/m-p/728635#M41269 BlakeTerhune 2016-11-04T21:53:08Z