Overview
Development function fields are accessible within queries based on the Household table. The following are available under the Development section of a household query:
- Amounts by Fiscal Year
- Amounts by Calendar Year
- Filtered Giving (BETA)
- Gift Date
Read more about function fields.
Amounts by Fiscal Year
This function field allows the user to search for the giving amount from a household for a particular year. To search across multiple fiscal years, add in multiple iterations of this function field and vary the parameters, updating the field description for clarity.
Parameters
| Fiscal Year (required) | Select the desired year, defaults to {current_fiscal_year}. |
| Gift Type (required) | Select one of the following:
|
Amounts by Calendar Year
This function field allows the user to search for the giving amount from a household for a particular calendar year. To search across multiple years, add in multiple iterations of this functions field and vary the parameters, updating the field description for clarity.
Parameters
| Calendar Year (required) | Select the desired year, defaults to {current_calendar_year}. |
| Gift Type (required) | Select one of the following:
|
Filtered Giving (BETA)
Please note this field is still in beta testing.
This function field allows users to search by gift type and by campaign.
| Gift Type (required) | Select one of the following:
|
| Campaign(s) | Select one of the campaigns that are displayed on the list of all campaigns in the system. |
Gift Date
This function field allows the users to search by the date a gift was posted.
| Option | Select a timing option for the gift.
|
| Gift Types | Select one or multiple gift types. Not required.
|
| Campaign(s) | Select one of the campaigns that are displayed on the list of all campaigns in the system. |