Feature Reports: Update Field From Previous Instance of Survey?

[JW_TT]

I've created a feature report for surveying the status of items in a factory. The items are surveyed once a month. The Survey123 survey looks great. The feature report template puts out a pdf that looks great. One of the fields on the survey is "Inspection Date" for the date of the survey. There is also a field "Previous Inspection Date." When the survey is first carried out, "Previous Inspection Date" will be blank. After a month, on the date of the second survey, I'd like the "Previous Inspection Date" field to be populated with the date of the first survey. Every month when the surveyor surveys a particular item, the date of the previous survey of that item is automatically populated.

I've tried "pullData" syntax in a variety of forms, but none seem to work. Am I just missing something? This must be a common process. I'm in a fairly strict corporate environment. Any suggestions, links, etc., would be great.

Thanks!

[ElishaStephens-Graham]

I have a similar query. The asset is created in a new survey form and then condition assessment activities are created within repeats - each condition assessment activity for the asset is a new repeat in the original survey form.

I'd like the main survey form to show the condition assessment value selected in the previous repeat (a select_one). The purpose is to allow symbology on the feature layer/web map by "current" condition rating.

CoPilot suggested this but I ran into issues as the repeat q is a select_one not a text field.

[DougBrowning]

I am not sure if max() will work on dates but you could try it quick.

On your code position only works inside the repeat.  Instead you can do count(somerepeatfield) to get the number of repeat records.  Then use that in indexed-repeat.