topic Re: Calculating the highest value of a field in ArcGIS Survey123 Questions

Calculating the highest value of a field

dsinha — Thu, 30 Apr 2026 19:08:40 GMT

Hello all,

I am using the solution suggested by Ismael in this post to calculate the next highest value in the idlong field.

There are no error messages but the value that is being produced is 401 (in ArcGIS Survey123 Connect) instead of 18320972.

Any clue what I could be doing wrong?

Thanks for your help!

Re: Calculating the highest value of a field

Neal_t_k — Thu, 30 Apr 2026 19:43:12 GMT

Something else you could try:

pulldata("@layer", "getValue",""attributes.<idlong>", "<url> ?orderByFields=<idlong> DESC"

This should sort greatest to least and return the greatest.

Survey123 Tricks of the Trade: pulldata("@layer") - Esri Community

Re: Calculating the highest value of a field

dsinha — Thu, 30 Apr 2026 19:51:33 GMT

Thanks for the suggestion @Neal_t_k. Where should I put the new expression: before I calculate the idlong_count field?

Re: Calculating the highest value of a field

Neal_t_k — Thu, 30 Apr 2026 19:55:09 GMT

You can replace the pulldata (@javascript) function with it. And obviously update the <xyz> with your appropriate info.

Re: Calculating the highest value of a field

dsinha — Thu, 30 Apr 2026 20:08:46 GMT

Sorry @Neal_t_k , it did not work. I am getting a blank now for idlong instead of a value.

Re: Calculating the highest value of a field

Neal_t_k — Thu, 30 Apr 2026 20:13:46 GMT

Whats your full pulldata() calculation? or can you share your xlsx example?

Re: Calculating the highest value of a field

dsinha — Fri, 01 May 2026 14:34:21 GMT

Thanks for taking the time @Neal_t_k. I have attached the XLSX file. I am also including the javascript.

Re: Calculating the highest value of a field

Neal_t_k — Thu, 30 Apr 2026 20:42:47 GMT

What is the attribute name of the field in your feature service that contains the idlong data. In your pulldata @javascript function you are referenceing ${idlong} which you are calculating with the results. The results of the calculation should return a number and not a field name. probably why it is returning 401, because it is a cyclic redundancy. You should hardcode that field name from your feature service instead of referencing a question.

I still think you could try using this by replacing "<idlong>" with your field name that contains the idlong data your are trying to return.

pulldata("@layer", "getValue",""attributes.<idlong>", "https://arcgissvr.borough.carlislepa.org/server/rest/services/Hosted/DataCollectionInspection/FeatureServer/0?orderByFields=<idlong> DESC"

Hope that makes sense.

Re: Calculating the highest value of a field

dsinha — Fri, 01 May 2026 14:35:55 GMT

Unfortunately, I am not sure how to hardcade a field name. Thanks for all your help though @Neal_t_k !

Re: Calculating the highest value of a field

Neal_t_k — Fri, 01 May 2026 15:13:45 GMT

Right here:

instead of calling a question from the form. insert the name of the field in your feature service corresponding to the idlong data. so instead of ${idlong} to would be "idlong" assuming that is your field name.

or in the pulldata @layer it would be:

pulldata("@layer", "getValue",""attributes.idlong", "https://arcgissvr.borough.carlislepa.org/server/rest/services/Hosted/DataCollectionInspection/FeatureServer/0?orderByFields=idlong DESC")

again assuming idlong is the field name in the feature service.