https://community.esri.com/t5/arcgis-survey123-questions/survey123-automatic-sequence-id-calculation/m-p/1295872#M49696 <P>You can use count() or position() but neither are perfect.&nbsp; If they go back in a repeat and delete a value it gets all messed up.&nbsp;&nbsp;</P><P>Have you seen this post&nbsp;&nbsp;<A href="https://community.esri.com/t5/arcgis-survey123-blog/creating-ticket-numbers-in-survey123-for-arcgis/ba-p/898870" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/creating-ticket-numbers-in-survey123-for-arcgis/ba-p/898870</A></P><P>&nbsp;</P> Mon, 05 Jun 2023 16:36:36 GMT DougBrowning 2023-06-05T16:36:36Z https://community.esri.com/t5/arcgis-survey123-questions/survey123-automatic-sequence-id-calculation/m-p/1292051#M49449 <P>Good day, ESRI Community</P><P>We have various concessions e.g.: A,B,C etc...</P><P>Each of these concessions have a set of sequence numbers starting at number 1.&nbsp;</P><P>The sequence number is based on the number of samples taken.</P><P>We would like a formula that looks at the existing feature service.</P><P>Firstly the concession name, and then the last sequence number of the concession, and then add 1 to the last sequence number.</P><P>Currently its a select from an external csv, which is incorrect.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SequenceID Calculator.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/71411iA71547ECAAB26E3A/image-size/large?v=v2&amp;px=999" role="button" title="SequenceID Calculator.png" alt="SequenceID Calculator.png" /></span></P> Tue, 23 May 2023 13:18:43 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-automatic-sequence-id-calculation/m-p/1292051#M49449 UlrichVanderHeyde 2023-05-23T13:18:43Z https://community.esri.com/t5/arcgis-survey123-questions/survey123-automatic-sequence-id-calculation/m-p/1295872#M49696 <P>You can use count() or position() but neither are perfect.&nbsp; If they go back in a repeat and delete a value it gets all messed up.&nbsp;&nbsp;</P><P>Have you seen this post&nbsp;&nbsp;<A href="https://community.esri.com/t5/arcgis-survey123-blog/creating-ticket-numbers-in-survey123-for-arcgis/ba-p/898870" target="_blank">https://community.esri.com/t5/arcgis-survey123-blog/creating-ticket-numbers-in-survey123-for-arcgis/ba-p/898870</A></P><P>&nbsp;</P> Mon, 05 Jun 2023 16:36:36 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-automatic-sequence-id-calculation/m-p/1295872#M49696 DougBrowning 2023-06-05T16:36:36Z