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 Material

This submission requirement prevents application submission if the applicant has not uploaded specific material.

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) that includes a filter for Material Name.

Require a Minimum Number of Materials

This submission requirement prevents application submission if the applicant has not uploaded the minimum number of materials based on material type. (Example is looking for at least 2).

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) that includes a filter for Material Name.

Require One Material OR Another (Either-Or)

In some cases, there may be various types of materials that they can submit. For example, you may have two materials, "Essay 1" and "Essay 2". You may wish for the applicant to submit Essay 1 OR Essay 2. Once one of these materials exists for an application, the application will no longer meet the filter criteria, and this submission requirement will not appear on the Review page. 

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) that includes a filter for Material Name for each material separated by an OR.

Require a Material (Transcript)

This submission requirement prevents application submission if the applicant has not uploaded a specific transcript material for a school entered on an academic history page.

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 - Exists) that includes two nested subquery filters for the level of study and the existence of a transcript material.