COVID-19 support
Sample surveys to support COVID-19 efforts
The coronavirus pandemic is front of mind for all of us. This crisis has changed the way we work, and many in our community are having to adapt to new challenges and requirements in response to COVID-19. A key example is the increased demand for the collection and analysis of coronavirus-related data.
With that in mind, we have published a set of COVID-related templates in ArcGIS Survey123 Connect. These templates alone are not intended to be an end-to-end solution for your COVID-19 needs. Like other community templates, the purpose is to provide practical examples of what you can do with ArcGIS Survey123 and demonstrate best practices for building smart forms with XLSForm.
Esri offers a range of GIS resources and solutions to help you monitor and respond to the pandemic. This includes maps, applications, and data. For more, see Esri's COVID-19 home page and COVID-19 GIS Hub .
You can try each of these sample surveys live in the Survey123 web app, or follow the instructions below to create and publish your own version of a survey in Survey123 Connect.
Inpatient Screening
This survey is an example of a form that could be completed by a health worker when a patient is admitted to a health facility. Collect personal information about the patient and details about any symptoms the patient is presenting with.
The example also uses table-list to display a block of select_one questions that each have the same choices. It also demonstrates how to use the string-length() function in the relevant column to check if an answer has been provided to a question, as well as a signature question to record a digital signature of the referring clinician. For more information, see Survey123 Tricks of the Trade: Signatures .
Testing Request
This survey is intended to be completed by a health worker requesting a laboratory test for COVID-19. The clinician can collect information about the patient and the specimen type being submitted for analysis.
The XLSForm demonstrates how to validate that a date of birth matches an age (in years), and apply this check as a constraint. It also shows how to use the relevant column to control the visibility of questions on the form based on responses to other questions and how to apply the table-list appearance (or Single Choice Grid, as it's called in the web app) to present a group of select_one questions in an easy-to-read table layout. For more information, see Survey123 Tricks of the Trade: Groups, Grids and Pages .
Symptoms Check
This survey provides a self-assessment of COVID-19 symptoms and is intended for use by the general public. The form could be useful for counties or cities in their efforts to measure the general impact of COVID-19 infection.
One of the key features of this survey is that it's in multiple languages. The XLSForm shows how to set labels, hints, and choices in English and Spanish. For more information on working with multiple languages, see Survey123 Tricks of the Trade: Introducing Multilingual Surveys . This sample was provided courtesy of Routt County, Colorado .
Community Support
This is a survey to help people connect with their community. Respondents can use this form to request support from their neighbors or offer help to others. This survey is designed as a single form that gathers both requests for help and offers of help. If required, you could split it into two separate surveys for requests and offers. The respective rows in the XLSForm have been highlighted in blue and orange. Delete the blue rows for one, and the orange rows for the other. You'll also need to remove the yellow row and the selected() function from the relevant column in each case.
This XLSForm sample demonstrates a technique to split out the responses to a select_multiple question into separate fields. A select_multiple question stores its answers as a comma-separated string. Using the selected() function, you can record the choices individually in separate hidden fields. To learn more, see Understanding Multiple-Choice Questions in Survey123 . This form also uses a regular expression to validate that an email address is formatted correctly. This expression is described in the Esri Community blog post The art of hiding .
ArcGIS Solutions
ArcGIS includes a collection of solutions designed to help you respond to the pandemic, begin recovery efforts, and return to the workplace. Most of these solutions leverage the power of ArcGIS Survey123 smart forms. For more information, see the ArcGIS Solutions gallery .
