Data Tables

DevResults provides a data submission and approval process that ensures that after direct entry indicator data has been submitted and approved, it can no longer be edited by users with limited permissions. With the data table row locking featu...

For all users, data table access is first determined by the user's permissions group. Two permission areas govern access to data tables, and each user group can defined with an option for each area: The Data Table Contributor permission ar...

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...

When an indicator's results are calculated from a data table, rows of the data table get assigned to a reporting period based on:  The date in the data table row (in the column defined as the indicator's date column ) The activity r...

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 — and especially the activity's partners — to report information in the...

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...

DevResults integrates fully with SurveyCTO , a mobile data collection tool. Surveys in SurveyCTO can be imported to DevResults as a data table. In this article: Create a data table and import SurveyCTO data Refresh an existing table with Surv...

Context Some DevResults sites include may locations and administrative divisions. When adding data to a data table, this can make the drop-down menu difficult to use. This video shows how to limit the geographies available in a data table to...

When setting up a new data table indicator, it's quite common to see "No data..." messages on the Data or Reports tab, even when the linked data table has many rows of data. Even if data appears, you may not see all of the data you exp...