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

082d8112-e41b-4fc5-aef5-9c7beef46969:slate-showcase

Testing Queries Suitcase ID

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

Require a School with a Specific Level of Study

Prevents application submission if the applicant has not entered the required school level of study. In this example, applicants who do not have a school with the High School level of study will see the hard fail.

1. Type - Submission Requirement

2. Section: Custom Application Page, which will begin as "frm?"

3. Name - Provide the text that will display when the applicant is missing information.

4. Warning -Select Hard Fail.

5. Base - Configurable Joins - Application

6. Filters - Create a Subquery Filter (Aggregate - Not Exists)

Require at Least One School Type

Prevents application submission when applicants have not provided a school with a specific type or level of study. This hard fail is usually created in two parts: one for first-year students looking for at least one high school listed and transfer/graduate students looking for at least one undergraduate/graduate school listed. These hard fails usually have two filters; one for student type and one for the school information. The example below is looking for first-year students with less than one high school listed.

1. Type - Submission Requirement

2. Section: Custom Application Page, which will begin as "frm?"

3. Name - Provide the text that will display when the applicant is missing information.

4. Warning -Select Hard Fail.

5. Base - Configurable Joins - Application

6. Filters -  Create a Subquery Filter (Aggregate - Count).

Require Accurate Attended Dates

This hard fail displays when entering a school where the attended from date is greater than the attended to date. For example, a student attends from September 1, 2021 to March 1, 2021. These dates don't make sense, and students must fix these before submitting their application. 

 Type - Submission Requirement

1. Section: Custom Application Page, which will begin as "frm?"

2. Name - Provide the text that will display when the applicant is missing information.

3. Warning -Select Hard Fail.

4. Base - Configurable Joins - Application

5. Filters -  Create a Subquery Filter (Aggregate - Comparison).