Video: Linked Tables and Relational Data

Key Points from the Video

Context

We're nearly done with our project to bring you relational data tables. Relational data tables will allow you to link one or more tables by information common to both. For example, you'll be able to have one table of trainees and a separate table of all the trainings they attend without needing to repeat demographic information (age, sex, etc.) about them every time. This video walks you through the most common use cases for linked tables and shows you how to configure these tables in DevResults.

Conceptual overview [00:51]

The four most common use cases for linked tables are:

  • Repeat Interactions
  • Select Multiple
  • Hierarchical Entities
  • Double Link

Linked tables in DevResults [16:30]

  • From any page, click on Results > Data Tables.
  • Click on a data table.
  • Select the Design tab.
  • Configure how rows from that table will be shown in other tables using a Lookup Key.
  • Link to Data Tables with a Lookup Key configured by adding that table as a column.
NOTE: Our linked tables feature is still in beta. To use the feature, please Edit Your Profile to become a beta tester.

Get in Touch

We want to work with you to design the best linked tables for your projects. Please send us an email with the scenario you're working with at help@devresults.com.

If you would like to test the examples in the video, please enter your email address here. We'll send you a note as soon as we add you to the site.

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