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

You can create application logic to require the upload of materials.

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 a material

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

• Type: Submission Requirement

• Section: Select the application page on which the applicant uploads the material

• Name: Enter text to appear when applicant is missing the material

• Warning: Hard Fail

• Base: Configurable Joins - Application

• 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).

• Type: Submission Requirement

• Section: Select the application page on which the applicant uploads the materials

• Name: Enter text to appear when applicant is missing the materials

• Warning: Hard Fail

• Base: Configurable Joins - Application

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

Require one material OR another

You may have two or more materials, for example, Essay 1 and Essay 2, and you may only require that an applicant submit one or the other.

Once one of these materials exists on an application, the application longer meets the filter criteria, and this submission requirement will not appear on the Review page.

• Type: Submission Requirement

• Section: Select the application page on which these materials are uploaded

• Name: Enter text to appear when applicant is missing both materials

• Warning: Hard Fail

• Base: Configurable Joins - Application

• Filters: Create a Subquery Filter (Aggregate: Not Exists) that includes a Material Name filter for each material separated by an OR operator.

Require transcript material

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.

• Type: Submission Requirement

• Section: Select the application page on which transcripts are uploaded

• Name: Enter text to appear when applicant is missing a transcript material

• Warning: Hard Fail

• Base: Configurable Joins - Application

• 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.