📚 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 examples 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-showcase

Testing queries Suitcase ID

a04770f5-349d-4e95-a9c0-0c5d0b1ba3b0:slate-examples

Warn if a test score is missing

Warn the applicant if they have not uploaded a specific test score.

• Type: Submission Requirement

• Section: Select the application page that includes test scores

• Name: Provide the text that will display when the applicant is missing information.

• Warning: Soft Fail

• Base: Configurable Joins - Application

• Filters: Create a Subquery Filter (Aggregate - Not Exists) that includes a filter for Test → Type.

Require one test OR another

For example, you may wish to warn the applicant if they have not submitted, for example, a GMAT OR GRE score.

Once one of these tests types exists for an application, the application will no longer meet the filter criteria, and this submission requirement will not appear on the Review page.

• Type: Submission Requirement

• Section: Select the application page that includes test scores

• 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) that includes a filter for Test → Type for each test, separated by an OR operator.

📖 More submission requirements you can create in Slate