Find a Recipe

Filter the cookbook’s recipes by calculation mode and aggregate operation, then jump straight to the recipe you need. Links open the recipe’s page with its card expanded.

37 of 37 recipes

Account: Address Type Count Affiliations, Relationships, Accounts, Contacts Count Watch for Changes
Account: Count Number of Contacts Affiliations, Relationships, Accounts, Contacts Count Realtime
Account: Count of Student Applications This Year Students, Scores, Attendance Count Watch for Changes
Account: First Event Purchased Date Campaigns, Registrations, Applications Min Invocable by Automation
Account: Largest Grant Received Outbound Funds Max Realtime
Account: Last Grant Received Outbound Funds Max Realtime
Account: Sum of Awarded Grants Outbound Funds Sum Realtime
Campaign: Campaign Hierarchies of Opportunities Opportunities, Payments, Allocations Sum Watch for Changes
Campaign: Total Amount Won from Opportunity Record Type or Lead Source Opportunities, Payments, Allocations Sum Realtime
Contact: Authorized Pickup Contacts Students, Scores, Attendance Concatenate Realtime
Contact: Campaign of First Donation Campaigns, Registrations, Applications First Watch for Changes
Contact: Completed Log-a-Call Activities LastYear Files, Activities Count Invocable by Automation
Contact: Concatenate Special Relationship to Organization Affiliations, Relationships, Accounts, Contacts Concatenate Distinct Realtime
Contact: Count All Campaign Memberships Campaigns, Registrations, Applications Count Realtime
Contact: Count Campaign Memberships by Type Campaigns, Registrations, Applications Count Invocable by Automation
Contact: Count Current Board Member Affiliation Affiliations, Relationships, Accounts, Contacts Count Realtime
Contact: Count Relationships to Accounts Affiliations, Relationships, Accounts, Contacts Count Realtime
Contact: Current Active Recurring Donations Opportunities, Payments, Allocations Count Realtime
Contact: Current Program Engagement Status Campaigns, Registrations, Applications Last Realtime
Contact: Current Traction Rec Membership Type Students, Scores, Attendance Concatenate Distinct Realtime
Contact: Find Completed Courses Education Data Architecture Count Realtime
Contact: Finding Count of Completed Program Enrollments Education Data Architecture Count Realtime
Contact: Finding Last Completed Program Enrollment Education Data Architecture Last Realtime
Contact: List of Years Engaged in Programs Campaigns, Registrations, Applications Concatenate Distinct Realtime
Contact: Sum of Won Tribute Gifts Opportunities, Payments, Allocations Sum Realtime
Contact: Tag Contact as a Major Sustainer Opportunities, Payments, Allocations Sum Watch for Changes
Contact: Tag Contact as an Active Sustainer Opportunities, Payments, Allocations Last Invocable by Automation
Course Offering: Find Total Enrollment Count Education Data Architecture Count Realtime
Course: Finding Next Course Offering Date Education Data Architecture Min Realtime
Funding Program: Count Applications Submitted Outbound Funds Count Realtime
Funding Program: Sum of Recommended Amount Outbound Funds Sum Realtime
Object: Count Attached Files with Certain Text in their Name Files, Activities Count Realtime
Opportunity: List GAU Allocations Opportunities, Payments, Allocations Concatenate Distinct Realtime
Opportunity: Sum of Paid Payments This Financial Year Opportunities, Payments, Allocations Sum Realtime
Opportunity: Sum of Paid Payments This Relative Fiscal Year Opportunities, Payments, Allocations Sum Realtime
Report Card: Calculate Grade Point Average (GPA) Students, Scores, Attendance Average Realtime
Require Receipts on Expense Reports Files, Activities Count Realtime