Update Field From Last Survey

Question

I am making an inspection form for people to fill out. There are a lot of questions that are highly likely to stay the same every inspection. I want to be able to autopopulate the field with their previous answer.

With a test survey, I successfully got it to pull the submitted data from the feature layer and bring it into the survey. However, when I add a new survey response with different answers it does not update. For example I did one survey with ID 1 and blue, then that worked but after doing ID 1 with green it still displayed blue.

I have it sorted by an automatic now() datetime. I also have looked in the test query and tested to see the most recent response with the same sort parameters and the output was correct. I attached an image of my form, I'm sorry it is not the correct format - I'm not sure how to upload it as a document preview of the xlsx form!

Any help would be appreciated. Thank you!

Autopopulate.png

Neal_t_k · Answer

@allyf Just noticed you have your sort and records at the end of your query, they should be part of the url. Try this:

pulldata("@layer", "getValue", "attributes.select_q", "<url>?orderByFields=Current_DT DESC&resultRecordCount=1", ${whclause1})

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3

(Request parameters section)

allyf · Answer

I have tried both of those. I was also pretty sure I could confirm that it should be ordered correctly because I ran a sample query. I am stumped! Thank you though.

Neal_t_k · Answer

In that case, maybe try sorting by a different field,  You could try descending on objectid or creationdate and see if that makes a difference.