topic Coding a Trigger to Update Data in One Field Based on Another in Developers Questions https://community.esri.com/t5/developers-questions/coding-a-trigger-to-update-data-in-one-field-based/m-p/619376#M4161 <HTML><HEAD></HEAD><BODY><P>I have a feature that will be used as an inspection.&nbsp; These inspections involve collecting measurements and then doing calculations with that information to determine whether the component is working properly.&nbsp; This was all previously done using pencil, paper, and a calculator.&nbsp; 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;</P><P></P><P>1. Is there code that makes this possible in a fgdb?</P><P>2. If it is possible, will that coding carry over to AGOL as we will be using Collector to do inspections?</P></BODY></HTML> Thu, 14 Jan 2016 15:13:39 GMT WightmanAdmin 2016-01-14T15:13:39Z Coding a Trigger to Update Data in One Field Based on Another https://community.esri.com/t5/developers-questions/coding-a-trigger-to-update-data-in-one-field-based/m-p/619376#M4161 <HTML><HEAD></HEAD><BODY><P>I have a feature that will be used as an inspection.&nbsp; These inspections involve collecting measurements and then doing calculations with that information to determine whether the component is working properly.&nbsp; This was all previously done using pencil, paper, and a calculator.&nbsp; 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;</P><P></P><P>1. Is there code that makes this possible in a fgdb?</P><P>2. If it is possible, will that coding carry over to AGOL as we will be using Collector to do inspections?</P></BODY></HTML> Thu, 14 Jan 2016 15:13:39 GMT https://community.esri.com/t5/developers-questions/coding-a-trigger-to-update-data-in-one-field-based/m-p/619376#M4161 WightmanAdmin 2016-01-14T15:13:39Z Re: Coding a Trigger to Update Data in One Field Based on Another https://community.esri.com/t5/developers-questions/coding-a-trigger-to-update-data-in-one-field-based/m-p/619377#M4162 <HTML><HEAD></HEAD><BODY><P>If you're just in a file geodatabase and ArcMap, the <A href="http://solutions.arcgis.com/shared/help/attribute-assistant/">Esri Attribute Assistant</A> 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. <A _jive_internal="true" href="https://community.esri.com/message/546705#546705">This reply</A> from <A href="https://community.esri.com/migrated-users/127588">Christopher Blinn</A> has some helpful alternatives.</P></BODY></HTML> Thu, 14 Jan 2016 16:21:43 GMT https://community.esri.com/t5/developers-questions/coding-a-trigger-to-update-data-in-one-field-based/m-p/619377#M4162 BlakeTerhune 2016-01-14T16:21:43Z