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 Custom Field

This example hard fail prevents the submission of an applicant when missing an application-scoped academic program or major, but could also be repurposed to search for Entry Term, student type, or any application-scoped field.

1. Type - Submission Requirement

2. Section: Select the page that displays the custom application field.

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 - Exists) for each field that should have a value saved.

  Best Practice

Be specific! Sometimes multiple fields can be combined and referred to in a single submission requirement on the application without confusing applicants; however, when combining many items on a page with many fields, it is often helpful to specify particular missing fields.

Two Applications Have the Same Program & Entry Term

This hard fail will display when the current applicant has submitted other applications with the same entry term. To access data from all applications, the subquery filter must join back from this application to the person record of the applicant, then join out again to all their existing applicants. Nested comparison filters between "Application" and "All Applications" determine that the overall filter looks for instances where a different, submitted application exists on the person's record, for the same entry term, with the same program selected. If you allow for multiple applications in a single round, but you don't want students to be applying to the same program multiple times, you can use this hard fail to prevent that.

1. Type - Submission Requirement

2. Section: Select the page that displays the custom application field.

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 Subquery Filters (Aggregate - Comparison).

Require Program Deadlines

Prevent the application submission if the applicant selected a program where that program’s special deadline has passed.

In this example, Biology applicants accessing the Review page after 01/05/2021 at 11:59:59 PM will receive a message that reads, "The deadline for this program as passed."

1. Type - Submission Requirement

2. Section: Select the page that displays the custom application field.

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 - Select a date using the Current Date Filter in combination with each field that should have a value saved.

  Best Practice

• Use the deadline on your application rounds whenever possible. If only some of your programs have different deadlines, you may decide to make submission requirements to accomplish this.

• Be sure to include all program-specific deadline information in your application instructions, so applicants know which programs are available.

• Program-specific deadlines should never occur after the application round deadline. The deadline on the round restricts all external access to the application after that date.