📚 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 digital portfolio material

This submission requirement prevents application submission if the applicant applies to a specific major and has yet to upload a digital portfolio material.

Note that the Application Major is a custom field you must create before creating this hard fail.

• Type: Submission Requirement

• Section: Select the Portfolio page, denoted by part ID upl?portfolio

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

• Warning: Hard Fail

• Base: Configurable Joins - Application

• Filters: Configure the following:

  1. Create a Subquery Filter (Aggregate - Not Exists).

  2. In the subquery filter, create a join to Materials.

  3. In the subquery filter, create a Subquery Filter (Aggregate - Formula)

  4. In the nested subquery filter, select Export.

  5. Select the Materials → Key export.

  6. Rename the export material_key.

  7. In the nested subquery filter’s Formula field, enter @material_key = ‘portfolio’

  8. Save the nested subquery filter.

  9. Save the subquery filter.

  10. Create a filter for a specific application major, if applicable.

📖 More submission requirements you can create in Slate