Create Weekend Event Mailings for Internal Staff
  • 04 Apr 2024
  • 2 minute read
  • Dark
  • PDF

Create Weekend Event Mailings for Internal Staff

  • Dark
  • PDF

Article summary

☑️ Prerequisite Skill

Liquid Looping

This article covers the steps required to send mailings to specific staff members in conjunction with certain events. The example used here concerns weekend events, and messages only the facilities manager to inform them which buildings will need to be open on the day of the event. 

Create the mailing

First, develop the text of the mailing you'd like to send.

  1. From the main navigation, select Deliver.

  2. Click New Mailing. In the popup:

    • Name: Give your mailing a descriptive internal name. In this example, Notify Facilities of Weekend Events 

    • Folder: Keep organized by placing the new mailing in an existing folder, or select Other to create a new one.

  3. Click Save.

  4. Click Edit Message. In the popup:

    • Add a Subject. In this case, Campus Buildings Required for Weekend Event.

    • Compose your message in the WYSIWYG editor.

  5. Click Save.

Create the recipients list query

This query will:

Pull events with a dictionary export,

Filter them to events happening this weekend, and

Filter recipients based on their GUID

 Create the query

  1. Click Edit Recipients List.

  2. Click New Query. In the popup:

    • Name: Give your query a descriptive name. In this example, Notify Facilities Weekend Events.

    • Sharing: Select this option if you want to share this query with other users with the query and query base permissions.

    • Type: Configurable Joins

    • Category: Related

    • Base: User

  3. Click Save.

Create the events export

  1. Click Edit Query. 

  2. Click Subquery Export.

  3. In the popup, configure the following:

    • Name: Events

    • Type: Independent subquery

    • Category: Related

    • Base: Form

    • Output: Dictionary

    • Exports: Create exports for any detail about an event you'd like to pull in to the mailing as merge fields. Note: All export names must be computer-friendly (lowercase, no spaces) for liquid looping purposes.

  4. Click Save.

Filter for weekend events

  1. Create a Subquery Filter that targets this weekend's events. In the popup:

    • Name: Give the subquery filter a descriptive name. In this example, Events Happening This Weekend.

    • Type: Independent Subquery

    • Category: Related

    • Base: Forms

    • Aggregate: Events

    • Create filter logic that restricts exports to only events happening this weekend:

      • (

      • IN Folder (add folders as needed)

      • OR

      • IN Template (add templates as needed)

      • )

      • IN Status: Confirmed/Active

      • Start Date: >= today + 1

      • Start Date: <= today +2

  2. Click Save.

Filter for relevant personnel

If the facilities manger does not yet have a user account in Slate:

  1. From the main navigation, select Settings, then User Permissions.

  2. Click New User.

  3. Enter the individual's name and email. 

  4. Click Save. A dialog appears saying "This account has not been enabled for access. Do you want to continue?"

  5. Click Continue.

  6. On the right, under Users & Activity, select Inactive Users.

  7. In the page's URL, you'll find the user GUID after /user?id=

  8. Copy the GUID.
    If the facilities manager already has a user account in Slate, copy their GUID using the previous method. You can also query on user GUID using the configurable join related base User.

    1. Return to the Create a Filter.

    2. Select GUID. Click Continue.

    3. In the GUID field, paste the facilities manager's user GUID.

    4. Click Save.

Add liquid looping and merge fields to the mailing

  1. Using the breadcrumb navigation, return to the mailing overview page.

  2. Click Edit Message.

  3. Click the Source button.

  4. Add the following to the mailing's HTML:

    {% for event in events %} Date and Time: {{event.startdate}}
    Event: {{event.title}} in {{event.location}}
    {% endfor %}


📖 Further Reading

You can find more resources covering liquid markup in the article Fundamental Liquid Markup and Conditional Logic and in the webinar The Joy of Liquid Markup.

Was this article helpful?