Survey123 offline edit csv or sqlite

Question

Is there anyway to edit csv file or the sqlite database using Survey123 offline or it is in a Survey123´s roadmap enhancement?
My problem is that I have a csv file with a list of IDs that I can not duplicate in another collect in the same device offline.

AndrewPadilla · Answer

Hi @Fabio_Pires, I have a similar set up with not wanting to duplicate surveys, in my case households. We have multiple surveyors working offline and sometimes we get people surveying the same household. My work around while not perfect is to include a to include a "IsSurveyed" field in my csv. When a new survey is started this field is pulled using pulldata function and if its true then a warning note pops up saying the house has been surveyed. You could prevent the survey from being submitted if desired.  While this doesn't prevent surveys from being collected and submitted we have an error check that will filter the data out duplicate data prior to uploading. Which allows us to rectify issues prior.  I hope that helps.

Below is my calculation

if(pulldata('vPersonTable123', 'IsSurveyed','name',${InterviewedCal})=1,concat("⚠ This household has been surveyed.⚠"), '')

LTS_DSolari · Answer

I doubt the app's internal databases will become user-accessible, that's a good way for people to corrupt the app for little gain.

As for CSV files, if you link them to portal items you can update a single item and every device will get an update once they regain internet access. You should also be able to download the survey package from your portal using Survey123 Connect, which will save all of the relevant data (including CSV choice lists) to your PC. If you need to manage an entire project within a fully disconnected environment then I'm not sure Survey123 is going to work, although I'd love to hear from people in those conditions about how they work with ArcGIS.