Application Portals
  • 22 Nov 2023
  • 4 minute read
  • Dark
  • PDF Application Portals

  • Dark
  • PDF

Article Summary

Slate provides a Application Portal template that can be imported using Briefcase and edited in an institution's database. This portal is configured to display custom institutional information. 

Briefcase: 33c9070d-c308-de8d-09ca-e175e2a4d1d2@slate-showcase

Additionally, new Application and Organization portals can be created in the Portal Editor.



Be sure to enable Application Sharing.

  1. Click Database in the top navigation bar and select Application Sharing Settings.

  2. Review the Rounds, Application Status, Checklists, Materials, and Decisions sections.

  3. Click on an individual item to then select either

    • Share with institutions

    • Do not share with institutions

Click the Slate Scholar Lightbulb    in the top left corner for a complete listing of all setting descriptions.

Create the Portal Queries

Once the Applicant Display portal has been imported via Briefcase, the exports can be customized to return the data points to display in the portal.

Application Details

We'll start with a Configurable Joins - Application query to pull a list of exports that can be used as merge fields. For example, if you wish to display the applicant's entry term, major, and decision for your institution, you would add those exports to the query.

  1. From All Portals, select your Application Portal from the list.

  2. Under Queries, click New Query.

  3. Configure the following in the New Query popup:

    • Name: Application Data

    • Type: Configurable Joins

    • Base: Applications

  4. Click Save to start editing the query.

  5. Add any exports.

  6. On the right, click Rename Exports. Make sure all export labels are lowercase, and use underscores, not spaces. Click Save.



By default, the query also has a filter for GUID that should not be removed: it ensures the query will export the data of the applicant being viewed.

If you accidentally remove the filter and need to add it back, its custom SQL is as follows:

GUID = @identity

No other filters are necessary for this query. The GUID filter limits the results to just the applicant clicked on in the portal.

Sharing Decision Reasons

The custom join to Decisions accomplishes the following:

  • Isolates decisions that have been released prior to today. This can be updated based on when you would like to share additional decision details. 

  • Selects decision codes that are also marked to be shared in the Application Sharing Settings. Note: This is an example! You will need to update this decision code filter to pull codes from your Slate database specifically. 

  • Sorts by Decision Release Date

  • Includes a Row Offset of '1', which will pull the most recently released decision.



A Configurable Joins - Form Response query will allow you to pull events that students have registered for or attended. This is an example of how you can help counselors see how their students have engaged with your campus. 

This query has an identity filter that looks for person and application-scoped form responses:

fr__JID_.[record] IN (@identity,(select [person] from [application] where [id] =@identity))

Exports can be used to define which event details you would like to share with counselors in the portal view.

Create a Portal View

The standard Application portal comes with pre-defined content blocks. You may also edit the views to display any additional data points added to the queries, remove items, or reformat in a different visual layout. 

Application Details View

The Application Details view includes several static content blocks, containing images, merge fields, Liquid markup, and snippets. The table widget pulls in data from the linked Events query. Review the article on  portal table view widgets before editing the existing widget or adding a new widget.



Think about leveraging dynamic content blocks to display information, such as staff assignments or advisors. This allows edits to the content blocks to dynamically update the information that displays in the portal, too!

The customized content in the Application Portal will appear below the standard data sharing content and to the left of the checklist (if configured to share in your Application Sharing Settings).


Create a Portal Method

A portal method is needed to tie the portal query and the portal view together.

Application Method

The Application method is configured as follows:

  1. From All Portals, select your Application Portal from the list.

  2. Under Methods, select New Method.

  3. Configure the following in the Edit Details popup: 

    • Name: Application

    • Type: GET

    • Leave Action blank.

    • View: Application

    • Output Type: Default Branding

    • Status: Active

It is unlikely any of these settings will need to change. Don't hesitate to reach out via the Service Desk if you believe you might need to alter one of these settings.

A list of queries display below these settings. This method is linked to the "Application Details" query. If any other queries were created, such as a query that generates a list of test scores or other items, you can:

  1. Click Edit Linked Queries in the top right.

  2. Select the additional queries.

  3. Click Save.

Portal Method



To test the Application portal:

  1. From All Portals, select your Application Portal from the list.

  2. On the right, select Impersonate.

  3. In the Record field, start typing the name of an applicant record. Select the applicant you'd like to impersonate from the list.

  4. Click Impersonate.


Best Practices

Avoid putting too much information in the portal. Consider what information is truly helpful to counselors, and be sure to limit the amount of Personally Identifiable Information included.

Remember that portals are dynamic! Updates to data and design elements within the portal will be immediately reflected in 

Keep the portal status Inactive until ready to make live. 

Was this article helpful?

What's Next