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