Data Tables

Articles

Create a Data Table
Data Tables versus Direct Entry Indicator results can be entered directly, or they can be pulled from a data table. For a quick breakdown on when to use Data Tables versus Direct Entry, take a look at the Indicator Guidebook . What Goes In a...
Data Tables: how does data get assigned to and displayed in reporting periods?
First, the system looks at the Date column that you defined in your data table indicator's mapping. (This is part of why we require the date column in data tables!) Based on that date, the system checks the start and end dates for reporting per...
Data Table Row Locking
One of the reasons people want to use DevResults is to provide a way to formalize data submission, review, and approval processes--and to guarantee that approved data can be "finalized" and become the data of record moving forward. We pro...
Who Has Access to Data Tables
System administrators for your DevResults site can set permissions for data table access for all user groups . Each user group within your organization can have: "View & Edit" or "View" access to all data tables, or "...
Interacting with Data Tables
Most users work with several thousand records in individual data tables. Much like Excel, DevResults allows you to interact with data tables to search for specific records, filter columns for specific information, and sort columns to group certain v...
How are Activities Linked to Data Tables?
Context When a data table is linked to an activity, it appears in the data table dropdown menu for an activity's reporting period. This allows the activity to report information in the table. Data Structure Data tables are explicitly  ...
Dates in Excel
Having trouble with dates? Excel stores dates behind the scenes as the number of days since 1 Jan 1900. For example, 31 Dec 2020 is 44196. DevResults is only capable of reading that number or producing that number. It doesn't matter how your d...
Import Data From SurveyCTO
DevResults integrates fully with SurveyCTO , a mobile data collection tool. You can create a data table and import data from your SurveyCTO surveys in a single click.  In this article: Create a data table with SurveyCTO data Refresh an ...