nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculating the highest value of a field

dsinha

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!

Najděte více příspěvků označených jako

Accepted answers

All comments

Neal_t_k

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

dsinha

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

Neal_t_k

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

dsinha

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

Neal_t_k

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

dsinha

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

Neal_t_k

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.

dsinha

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

Neal_t_k

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.

dsinha

Good morning @Neal_t_k! I did try that approach based on an earlier suggestion of yours and it did not work.

This has been an enduring problem with Survey123 ever since I have been working with it. I ended up changing the way we are generating the number - we moved to a system of generating the number with current date and time. Thanks again for all your help!!

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.