topic Is there a code to auto populate a field with alphanumeric values in ascending order? in Data Management Questions https://community.esri.com/t5/data-management-questions/is-there-a-code-to-auto-populate-a-field-with/m-p/43343#M2425 <HTML><HEAD></HEAD><BODY><P>I have a field named FacilityID and it contains alphanumeric values that need to be populated in ascending order.&nbsp; Our current work flow involves "X-ing&nbsp;out" the last four digits, then sorting the field in ascending order, and then finally going one by one and manually filling them in.&nbsp; For example:&nbsp;</P><P><SPAN style="text-decoration: underline;">FacilityID</SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN style="text-decoration: underline;">FacilityID</SPAN></P><P>S-LL-L18-1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1002</P><P>S-<SPAN>LL</SPAN>-L18-1003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1003</P><P>S-<SPAN>LL</SPAN>-L18-1004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1004</P><P>S-<SPAN>LL</SPAN>-L18-1005&nbsp; &nbsp; &nbsp;-----------------------------&gt;&nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1005</P><P>S-<SPAN>LL</SPAN>-L18-xxxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S-<SPAN>LL</SPAN>-L18-1006</P><P>S-<SPAN>LL</SPAN>-L18-xxxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S-<SPAN>LL</SPAN>-L18-1007</P><P>S-<SPAN>LL</SPAN>-L18-xxxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S-<SPAN>LL</SPAN>-L18-1008</P><P></P><P>Is there a code that can auto populate the last four digits in ascending order? We would also need to specify which number the auto populate will begin at;&nbsp;in this case it would be starting&nbsp;at 1006 and then +1 after that.&nbsp;</P></BODY></HTML> Thu, 29 Nov 2018 16:59:32 GMT ClaytonGordon1 2018-11-29T16:59:32Z Is there a code to auto populate a field with alphanumeric values in ascending order? https://community.esri.com/t5/data-management-questions/is-there-a-code-to-auto-populate-a-field-with/m-p/43343#M2425 <HTML><HEAD></HEAD><BODY><P>I have a field named FacilityID and it contains alphanumeric values that need to be populated in ascending order.&nbsp; Our current work flow involves "X-ing&nbsp;out" the last four digits, then sorting the field in ascending order, and then finally going one by one and manually filling them in.&nbsp; For example:&nbsp;</P><P><SPAN style="text-decoration: underline;">FacilityID</SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <SPAN style="text-decoration: underline;">FacilityID</SPAN></P><P>S-LL-L18-1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1002</P><P>S-<SPAN>LL</SPAN>-L18-1003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1003</P><P>S-<SPAN>LL</SPAN>-L18-1004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1004</P><P>S-<SPAN>LL</SPAN>-L18-1005&nbsp; &nbsp; &nbsp;-----------------------------&gt;&nbsp; &nbsp; S-<SPAN>LL</SPAN>-L18-1005</P><P>S-<SPAN>LL</SPAN>-L18-xxxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S-<SPAN>LL</SPAN>-L18-1006</P><P>S-<SPAN>LL</SPAN>-L18-xxxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S-<SPAN>LL</SPAN>-L18-1007</P><P>S-<SPAN>LL</SPAN>-L18-xxxx&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S-<SPAN>LL</SPAN>-L18-1008</P><P></P><P>Is there a code that can auto populate the last four digits in ascending order? We would also need to specify which number the auto populate will begin at;&nbsp;in this case it would be starting&nbsp;at 1006 and then +1 after that.&nbsp;</P></BODY></HTML> Thu, 29 Nov 2018 16:59:32 GMT https://community.esri.com/t5/data-management-questions/is-there-a-code-to-auto-populate-a-field-with/m-p/43343#M2425 ClaytonGordon1 2018-11-29T16:59:32Z Re: Is there a code to auto populate a field with alphanumeric values in ascending order? https://community.esri.com/t5/data-management-questions/is-there-a-code-to-auto-populate-a-field-with/m-p/43344#M2426 <HTML><HEAD></HEAD><BODY><P>The attribute assistant as a method called Autonumber as well as GenerateID; not sure if deploying the AA would fit into your workflow or not....&nbsp;&nbsp;</P><P></P><P><A class="link-titled" href="http://solutions.arcgis.com/shared/help/attribute-assistant/documentation/methods-all-methods/" title="http://solutions.arcgis.com/shared/help/attribute-assistant/documentation/methods-all-methods/">All methods - Attribute Assistant | ArcGIS Solutions</A>&nbsp;</P><P><A class="link-titled" href="http://solutions.arcgis.com/shared/help/attribute-assistant/" title="http://solutions.arcgis.com/shared/help/attribute-assistant/">Attribute Assistant | ArcGIS Solutions</A>&nbsp;</P></BODY></HTML> Thu, 29 Nov 2018 17:16:31 GMT https://community.esri.com/t5/data-management-questions/is-there-a-code-to-auto-populate-a-field-with/m-p/43344#M2426 JoeBorgione 2018-11-29T17:16:31Z