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!

Neal_t_k

I changed everything back to your variables, but the attached does pull the most recent date when I hook it up to one of my feature layers???  If  not it may have something to do with your feature layer settings, have you checked the share setting in Survey123 site. 

I am not sure if these setting would effect it but worth a shot

 

 

Form 6.xlsx