Latest Contributions by RobertGilson

We used to generate about 1000 reports a month using Survey123, but now with their new fee structure, we have stopped using the report service and replaced it with an excel to word workflow. The rest of our survey123/Collector/AGOL process has stayed the same. The excel to word process is less elegant than the reporting in survey123 since it requires transferring data from the database into an excel workbook, but does not cost us anything once setup and has been working fine for the past 3 weeks. It took me an afternoon to build the excel workbook and word template plus prepare a standard operating process for the coworkers that will be running reports. Our process is only partially automated but I am sure that it can be fully automated provided someone with time and coding skills set their mind to it. As a bonus, our reports look identical to the reports we would generate from Survey123. So from a deliverable standpoint, there was no change. I would consider moving back to the Survey123 process if the price was significantly lower but it would only be for convenience sake and even then, I might stay with this approach as it gives me more control over the process and output (I was able to code in some error checking into the excel workbook that warns the users if there are potential problems with the data). We are deploying this approach across more of our projects now that we have the template and work process figured out. So far I am still happy with ESRI's Survey123/Collector/AGOL services as a whole. I think ESRI has missed the mark on pricing the report generating service and I hope that they correct this mistake in the future. Until then, we will not be using the service much, if at all. This is the YouTube video that helped us develop our work process: How To Create Custom Word Documents From Excel WITHOUT Mail Merge - YouTube  Hope this helps those of you with reports and saves you some money! #Survey123 Reports #Survey123 Credits #Survey123 ... View more