---
title: "Associating Gifts to Pledges"
slug: "associating-gifts-to-pledges"
updated: 2026-02-26T00:36:20Z
published: 2026-02-26T00:36:20Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Associating Gifts to Pledges for Advancement

When a gift is applied towards a particular pledge, the gift inherits the unique ID (called the GUID) of the pledge. Slate stores this unique ID in a field on the gift table called Parent GUID. This association allows two primary conclusions to be drawn:

- Gifts with a value in the Parent GUID field are gifts that have been made in fulfillment of a pledge
- Slate knows which gifts are specifically associated with any given pledge

Utilizing this knowledge and the one-to-one join of **Received to Pledged**, a query can be created to return one row per gift that is associated with a pledge and the details of the original pledge will be listed as exports.

## Querying on gifts with pledges

While this type of querying can occur from the Person base, it is better demonstrated by starting with the Gift configurable joins base. To start:

1. Click **Queries / Reports** in the top navigation bar. Click New Query and enter the following in the popup:
  - **Name** - Provide a name for the query, such as "Associating Gifts to Pledges"
  - **Type** - Select "Configurable Joins"
  - **Category** - Select "Related"
  - **Base** - Select "Gift." This will return one row per gift in the query.
2. Add a main join to the **Person** base. Once added, add a few person exports to identify to whom each gift is associated. Add any other person-scoped filters as desired. In this example, the results have been limited to the gifts of Alexander Hamilton.
3. Add several **Gift Exports**, such as the date, amount, and status category of each gift. Add format masks, as necessary.

[![Associating_Gifts_to_Pledges_-_Setup.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044419532.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044419532.png)
4. Add the following **Filters** to return only those gifts that have been received and are associated with a pledge:
  - **Status Category** - IN Received
  - **Subquery Filter**
    - **Name** - Name the filter something descriptive, such as "Associated with a Pledge"
    - **Aggregate** - Exists
    - **Exports** - Add the "Parent GUID" export.

[![Associating_Gifts_to_Pledges_-_Subquery_Filter.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044499251.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044499251.png)

The total number of rows being returned in the query should now be equal to the number of gifts that have been received and have been applied towards a pledge.
5. To return details on the original pledge, a new join must be added. Because each received gift can only ever be associated with one pledge, a one-to-one join can be added that connects each received gift to the correct pledge. **Add** the **Received to Pledged** join off of the gift base.

[![Associating_Gifts_to_Pledges_-_Join.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044420572.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044420572.png)
6. Once the join has been added, click **Export** to return the details of the originating pledge, such as the pledge date and amount pledged. Format the exports, as desired.

[![Associating_Gifts_to_Pledges_-_Exports.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500511.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500511.png)

The final output should resemble the following, with the details of the received gift alongside the original details of the pledge:

[![Associating_Gifts_to_Pledges_-_Output.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500491.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500491.png)