Coding a Trigger to Update Data in One Field Based on Another

01-14-2016 07:13 AM
New Contributor III

I have a feature that will be used as an inspection.  These inspections involve collecting measurements and then doing calculations with that information to determine whether the component is working properly.  This was all previously done using pencil, paper, and a calculator.  We're hoping to avoid the need to post process the information collected in the field by automatically calculating result fields based on an equation that uses data entered in other fields. My questions regarding this are;

1. Is there code that makes this possible in a fgdb?

2. If it is possible, will that coding carry over to AGOL as we will be using Collector to do inspections?

0 Kudos
1 Reply
MVP Regular Contributor

If you're just in a file geodatabase and ArcMap, the Esri Attribute Assistant add-in may work for you. A traditional database trigger would require an RDBMS (like SQL Server or Oracle). Not sure about how to accomplish this with ArcGIS Online or Collector. This reply from Christopher Blinn has some helpful alternatives.

0 Kudos