Relationship Field¶
A relationship field allows to connect one table to another. For example, in a recruitment app, having the tables jobApplications
, applicants
and positions
, we can have the job applications connected to an applicant and a position:

We can implement this structure using relationship fields:
key: jobApplications
type: table
name: Job Applications
itemName: Job Application
summary:
title: "Candidate {{candidate.firstName}} {{candidate.lastName}} applying to {{role.name}} position"
fields:
applicant:
type: relationship
table: applicants
label: Applicant
position:
type: relationship
table: positions
label: Position
date:
type: date
label: Application Date
For this code to work, you need to have the applicants
and positions
tables defined as well. You only need to define the relationship field in the parent table, you don’t need to add anything on the child tables.
The form for creating a new job application will be presented like this:

More information in the YAML reference documentation.