Survey123 PullData Function Not Working

[JD1016]

Hello,

We've been using "pulldata" to extract information from a CSV file corresponding to our meter numbers.  The Account, Address, Route, and Seq are auto-filled based on the meter number entered.  This function was working fine since April, however, within the last few weeks Account, Route, and Seq are not added to the form after using the field app.  The field app shows the information populating as it should and the technician submits the collection event.  When we go to retrieve the data in Survey123 on AGO, that data is blank in those columns except Address is carried over correctly.

I've tried republishing the form and that does not work.  There are no visible differences in the Survey123 Connect form since we originally started this process and no extraneous characters from what I can see either.

Our field app version is 3.18.142 and our original survey  was published using 3.13. 

I've attached the csv file that is being referenced for the pull data function along with a screen capture featuring the XLS code.

Any assistance provided would be most welcome.

Thank you, Jeff

[ZacharySutherby · Accepted solution]

Hello @JD1016, 

It looks like there is a data type mismatch that's causing Survey123 to clear the values. What I would suggest is in your XLSForm set the bind::type to int and set the bind::esri:fieldType to esriFieldTypeString. 

[JD1016]

Hi Zach,

Thank you so much for replying over the weekend.

I implemented your suggestion and it worked perfectly!

I still am mystified by why it decided to have an issue after working just fine since April.  No change in the reference CSV was made at all.

Anyway...thank you again.

Jeff