As of July 12, 2021, this "Learn Veracross" site has been deprecated. It will remain live through December 2022, but will no longer be updated. All knowledge content has moved to the new Veracross Community. Please update your bookmarks.
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. |