Link Data Tables

Once you've created a Lookup Key for a table, you can use it to link records in one table to another. 

Linking Existing Data Tables

To link a data table to another, navigate to the data table you want to link. In this example, we'll be connecting the School table to a table of Teacher Records. 

Click on the Design tab.

This table already has several columns added, including the # years as a teacher, # years post-training, when the school year started, and where they are based. To pull in information about their school from the Schools table, click on (+) Add new column

In the popup, you can specify what the column should be called. Click on the dropdown for Type and select Table. You can now click on the Table dropdown and select which data table you would like to connect. 

Click on (+) Add Column.

Note: Tables will not show up in the dropdown if a Lookup Key is not specified for that table.  Tables will also now show up in the dropdown if you have not enabled the "Relational Data Tables" feature under Administration > Program Settings.

Once you've added the column, DevResults will display all columns available from related tables, including those currently available and ones that are pending. 

Once you've reviewed the pending changes, click on Save changes to link the tables. 

You can now navigate to the Data tab to begin pulling adding data, including information stored in the "Schools" table. 

Click on (+) Add new row. 


You'll notice that adding information to the new row remains the same. 

When adding information from the "Schools" table (column: School) to a row, you can click on the dropdown and select the School ID and Location you want to include in that specific column. 

Click Save to add the new row.

If you want to display the School ID and Location separately, you can do so by clicking on the gear icon on the top right corner of the table. 

In the list of columns below, you can choose to display any columns in the table you linked to this one. In our example, we can choose to display School: Urban/Rural, School: # classrooms, etc. If we want to remove the Lookup Key from the table, we can uncheck the box next to it. In our example, that would be the School column.

TIP: If you are creating a new data table by uploading an example that links to another table, values in one of the columns in the data table should match the generated Lookup Key in the second data table. In the example above, we would have added School as a column, with all values in the column formatted as School ID, School Location

Once you've created a linked table, you can start populating indicators with this data.

Didn't answer your question? Please email us at help@devresults.com.