📚 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 rank 1 address

This submission requirement looks for applicants who do not have a rank 1 overall address, which can be considered an Active Address. You can also create Individual hard fails for mailing and permanent addresses. Add a filter of Address Type and select the one which is needed.

• Type: Submission Requirement

• Section: Select the application page that includes biographical information.

• Name: Enter text to appear when application is missing a rank 1 address.

• Warning: Hard Fail

• Base: Configurable Joins: Application

• Filters: Create a Subquery Filter (Aggregate: Not Exists).

  

Require permanent address

Prevents submission of the application if the applicant has not entered a permanent address.

• Type: Submission Requirement

• Section: Select the application page that includes biographical information

• Name: Enter text to appear when applicant is missing permanent address information

• Warning: Hard Fail

• Base: Configurable Joins: Application

• Filters: Create a Subquery Filter (Aggregate: Not Exists) that includes a filter for Address Type.

  

Require mailing address

Prevents submission of the application if the applicant has not entered a mailing address.

• Type: Submission Requirement

• Section: Select the application page that includes biographical information

• Name: Enter text to appear when applicant is missing mailing address information

• Warning: Select Hard Fail.

• Base: Configurable Joins: Application

• Filters: Create a Subquery Filter (Aggregate: Not Exists) that includes a filter for Address Type.

  

Require postal code for US/CA mailing addresses

This hard fail looks for applicants missing a U.S. and Canadian citizenship postal code. Students residing outside of one of these countries will not see the hard fail.

• Type: Submission Requirement

• Section: Select the application page that includes biographical information

• Name: Enter text to appear when applicant is missing US/CA postal code information

• Warning: Hard Fail

• Base: Configurable Joins: Application

• Filters: Configure the following:

  1. Create a Subquery Filter (Aggregate: Exists).

  2. Create a join to Person,

  3. Create a join to Addresses.

  4. Create an Address Type filter IN Mailing Address.

  5. Create an Address Country filter IN Canada, United States.

  6. Create a Subquery Filter (Not Exists) and select the Postal export from the Addresses section.

     

Require citizenship information

This example prevents submission of the application if the applicant is missing a primary citizenship.

• Type: Submission Requirement

• Section: Select the application page that includes biographical information

• Name: Enter text to appear when applicant is missing citizenship information

• Warning: Hard Fail

• Base: Configurable Joins: Application

• Filters: Create a Subquery Filter (Aggregate: Not Exists) for the field that should have a value saved.