https://community.esri.com/t5/arcgis-survey123-questions/javascript-increment-based-off-another-field-in/m-p/1257026#M47425 <P>Hello!&nbsp;</P><P>I am new to coding, and I want to set up a function that will assign a "sitenumber" at an incremental value for each different sourceid. What I would like is for the function to first search for a "sourceid" (which is being populated by pulldata from an attached csv file), then find the maximum sitenumber for that selection of rows with that sourceid and add 1 to the next sitenumber. I believe I should be using the search() and increment functions, but unsure of exactly how.&nbsp;</P><P>Example: I have sourceid 1 and 2. I want sitenumber for sourceid 1 to go 1,2,3, etc. and sitenumber for sourceid 2 to go 1,2,3, etc. When new data is put in through the form, sourceid is autopopulated. Lets say to sourceid 2 in this example. I want the function to find the maximum sitenumber for sourceid 2 and add 1 to that.&nbsp;</P><P>Any guidance is greatly appreciated! Thank you!&nbsp;</P> Fri, 10 Feb 2023 15:13:47 GMT DelaneyMccarthy 2023-02-10T15:13:47Z https://community.esri.com/t5/arcgis-survey123-questions/javascript-increment-based-off-another-field-in/m-p/1257026#M47425 <P>Hello!&nbsp;</P><P>I am new to coding, and I want to set up a function that will assign a "sitenumber" at an incremental value for each different sourceid. What I would like is for the function to first search for a "sourceid" (which is being populated by pulldata from an attached csv file), then find the maximum sitenumber for that selection of rows with that sourceid and add 1 to the next sitenumber. I believe I should be using the search() and increment functions, but unsure of exactly how.&nbsp;</P><P>Example: I have sourceid 1 and 2. I want sitenumber for sourceid 1 to go 1,2,3, etc. and sitenumber for sourceid 2 to go 1,2,3, etc. When new data is put in through the form, sourceid is autopopulated. Lets say to sourceid 2 in this example. I want the function to find the maximum sitenumber for sourceid 2 and add 1 to that.&nbsp;</P><P>Any guidance is greatly appreciated! Thank you!&nbsp;</P> Fri, 10 Feb 2023 15:13:47 GMT https://community.esri.com/t5/arcgis-survey123-questions/javascript-increment-based-off-another-field-in/m-p/1257026#M47425 DelaneyMccarthy 2023-02-10T15:13:47Z