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

Testing queries Suitcase ID

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

Require recommenders

You can use this hard fail query to prevent applicants from submitting an application without indicating the required number of recommenders in the reference widget on the application.

The required number count can be adjusted to meet the needs of specific processes.

• Type: Submission Requirement

• Section: Select the application page on which you collect reference information

• Name: Enter text to appear when applicant is missing your required number of references

• Base: Configurable Joins - Application

• Filters: Create a Subquery Filter (Aggregate - Count) that filters for Material → Name where count is less than however many you require.

Require recommender type

You can use this hard fail query to ensure applicants identify within the reference widget the required recommenders by type. The recommender type can be adjusted based on the specific needs of the application requirements and institution.

• Type: Submission Requirement

• Section: Select the application page on which you collect reference information

• Name: Enter text to appear when applicant is missing a recommender of a required type

• Warning: Hard Fail

• Base: Configurable Joins - Application

• Filters: Create a Subquery Filter (Aggregate - Not Exists) that includes a filter for Material Name.

📖 More submission requirements you can create in Slate