topic Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. in Developers Questions https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719492#M4922 <HTML><HEAD></HEAD><BODY><P>Hi Dan, The fibre loop is a data point. So the AsBuiltLength represents the difference between begin and endmeasure. I want to add an algorithm to the&nbsp;<SPAN>AsBuiltLength field:&nbsp; AsBuiltLength =&nbsp;endmeasure -beginmeasure [or vice versa]. This will save a bit of time. Cheers, Sean&nbsp;</SPAN></P></BODY></HTML> Thu, 04 Jan 2018 23:56:04 GMT SeanKartun1 2018-01-04T23:56:04Z Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719490#M4920 <HTML><HEAD></HEAD><BODY><P>Please see the attached picture re the fields in question.&nbsp;</P></BODY></HTML> Thu, 04 Jan 2018 22:29:49 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719490#M4920 SeanKartun1 2018-01-04T22:29:49Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719491#M4921 <HTML><HEAD></HEAD><BODY><P>Are the data points? or a polyline? or do you only have the data in a table</P></BODY></HTML> Thu, 04 Jan 2018 23:09:26 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719491#M4921 DanPatterson_Retired 2018-01-04T23:09:26Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719492#M4922 <HTML><HEAD></HEAD><BODY><P>Hi Dan, The fibre loop is a data point. So the AsBuiltLength represents the difference between begin and endmeasure. I want to add an algorithm to the&nbsp;<SPAN>AsBuiltLength field:&nbsp; AsBuiltLength =&nbsp;endmeasure -beginmeasure [or vice versa]. This will save a bit of time. Cheers, Sean&nbsp;</SPAN></P></BODY></HTML> Thu, 04 Jan 2018 23:56:04 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719492#M4922 SeanKartun1 2018-01-04T23:56:04Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719493#M4923 <HTML><HEAD></HEAD><BODY><P>I take it you aren't using arcmap which would be a simple field calculation, so perhaps you might want to elaborate on which part of the <STRONG>'Developer'</STRONG> forest you are in.&nbsp; You can <STRONG>Share </STRONG>to a more directed space if you want (access to the top right of your question)</P></BODY></HTML> Fri, 05 Jan 2018 00:17:52 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719493#M4923 DanPatterson_Retired 2018-01-05T00:17:52Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719494#M4924 <HTML><HEAD></HEAD><BODY><P>Thanks, I'll return to the question on Monday.&nbsp;</P></BODY></HTML> Fri, 05 Jan 2018 06:19:00 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719494#M4924 SeanKartun1 2018-01-05T06:19:00Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719495#M4925 <HTML><HEAD></HEAD><BODY><P>Hi Dan, I am using ArcMap. I'm definitely in a forest, so I can't elaborate too much. Would you have any recommendations for sharing/tags?</P></BODY></HTML> Mon, 08 Jan 2018 23:53:50 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719495#M4925 SeanKartun1 2018-01-08T23:53:50Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719496#M4926 <HTML><HEAD></HEAD><BODY><P>Sean, if your data is in a relational database, a <A href="https://www.essentialsql.com/what-is-a-database-trigger/">trigger </A>could calculate the&nbsp;<SPAN style="background-color: #ffffff;">AsBuiltLength<SPAN>&nbsp;on an update to the&nbsp;endmeasure and beginmeasure fields (obviously checking that both are populated)..</SPAN></SPAN></P></BODY></HTML> Mon, 08 Jan 2018 23:58:47 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719496#M4926 MatthewDobson 2018-01-08T23:58:47Z Re: Is it possible to create an algorithm in the attributes value field of ArcMap? I want to calculate the final length from the start and end length fields. https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719497#M4927 <HTML><HEAD></HEAD><BODY><P>And you seem to indicate that you already have the information in fields... hence, no coding needed, no application development needed, just use the field calculator</P><P><A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/fundamentals-of-field-calculations.htm">http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/fundamentals-of-field-calculations.htm</A></P><P>and&nbsp;Pythagorean theorem to the rescue... assuming you can calculate the difference in the x and y coordinates from the fields.&nbsp; If you don't have them, then you can actually calculate the same values using the field calculator and retrieving the start and end points using arcpy in the field calculator.</P></BODY></HTML> Tue, 09 Jan 2018 00:20:35 GMT https://community.esri.com/t5/developers-questions/is-it-possible-to-create-an-algorithm-in-the/m-p/719497#M4927 DanPatterson_Retired 2018-01-09T00:20:35Z