Webinar: Linked Tables and Relational Data

Key Points from the Webinar

Context

Linked data tables allow you to connect one or more tables by information common to both. For example, you can have one table of trainees  that contains all their demographic information (age, sex, etc.) and a separate table of all trainings -- without needing to repeat demographic information about an individual for each training they attend. Another term for this method of organizing information is relational data; the data is related by a shared column. This webinar 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 Program Info > 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.

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.

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