Question About Modifying a Survey to Have Empty Columns

[KelvinDixon]

Hello, I'm pretty new to Survey 123 and I'm currently working on survey where the researchers would like to compare past data to the data being collected in the same sheet. I believe what they're asking is it is possible to input a previously taken data set that wasn't done in Survey 123, but I believe is in excel. And have it automatically filtered into a sheet that shows both data sets side by side. The easiest solution in my mind is once the data for this season is collected or as the data is being collected, to be converted into a csv file and edit it to create columns and fill them in with the correct title and data. I was wondering if there was an easier method of doing this. I do have access to ArcGIS Survey Connect and would be more than willing if there was some coding I could learn if it made it possible. I was also wondering if it's possible that when an option is selected to filter it out in the final results, so it won't show up.

Sincerely Kelvin Dixon

[abureaux]

Short answer is 'yes', but not the way I think you were hoping for. Yes, you can import data that wasn't taken in S123. You can append data to a database:

You will need to append your historical data so S123 can access it. There are other methods of accessing external data, but this is by far the easiest.

Once your historical data has been added, you can separate the historical and new data based on the various fields (this will be unique to your data). You will probably also need to utilize something like pulldata(@layer).

Good luck!