- 24 Oct 2025
- 1 minute read
- Print
- DarkLight
- PDF
Require Relationship Data
- Updated 24 Oct 2025
- 1 minute read
- Print
- DarkLight
- PDF
📚 Part of the series Application Building Phase II: The Slate-hosted Application
Application logic, including hard and soft fails, ensure applicants enter all necessary data prior to submitting an application.
Try a Slate example 💼
Use Suitcase to import the example in this article (and others in this section) into your institution's database. These examples are also featured in the Clean Slate Showcase environment.
Using testing queries
Before you commit to using the application logic records, try a testing query by importing the Suitcase link in the second tab. These queries recreate the application logic records, taking advantage of the Query Builder's Preview Results function to ensure the records that should be receiving the hard or soft fails appear. If you only use the application logic records, you'll only see the number of records affected.
Application logic Suitcase ID (hard fail library)
082d8112-e41b-4fc5-aef5-9c7beef46969:slate-admissions-showcaseTesting queries Suitcase ID
a04770f5-349d-4e95-a9c0-0c5d0b1ba3b0:slate-examplesRequire at least one parent or guardian
Your process may call for applicants to provide you with relational data. This hard fail requires an applicant to provide a relation type of mother, father, parent, stepmother, stepfather, or legal guardian.
Type: Submission Requirement
Section: Select the application page that includes relationship information
Name: Provide the text that will display when the applicant is missing information.
Warning: Hard Fail
Base: Configurable Joins - Application
Filters: Create a Subquery Filter (Aggregate - Not Exists) with a filter for Relations → Relationship Type
INFather, Legal Guardian, Mother, Step-Father, and Step-Mother.

