Contact Rollups: Adoption & Foster

The tables detailed below provide a summary of fields on the Contact record and the rollup logic applied to the fields.

animalos__Location__c – animalos__Movement__c (rollups data on all Foster Locations from their related Movement records)

Field	Logic

Field	Logic
`Foster_Animal_Count_Total__c`	Number of related Movements
`Foster_Days_Total__c`	Sum of `animalos__Total_Time_Days__c` of all related `Movements`
`Foster_Animal_Count_Last_5_Years__c`	Number of `Movements` where `Start Date/Time` or `End Date/Time` is within 5 years
`Foster_Days_Last_5_Years__c`	Sum of `animalos__Total_Time_Days__c` of `Movements` where `Start Date/Time` or `End Date/Time` is within 5 years
`Foster_Animal_Count_Last_Year__c`	Number of `Movements` where `Start Date/Time` or `End Date/Time` is in Last Year
`Foster_Days_Last_Year__c`	Sum of `animalos__Total_Time_Days__c` of `Movements` where `Start Date/Time` or `End Date/Time` is in Last Year
`Foster_Animal_Count_This_Year__c`	Number of `Movements` where `Start Date/Time` or `End Date/Time` is in This Year
`Foster_Days_This_Year__c`	Sum of `animalos__Total_Time_Days__c` of `Movements` where `Start Date/Time` or `End Date/Time` is in This Year
`Foster_Animal_Count_This_Month__c`	Number of `Movements` where `Start Date/Time` or `End Date/Time` is in This Month
`Foster_Days_This_Month__c`	Sum of `animalos__Total_Time_Days__c` of `Movements` where `Start Date/Time` or `End Date/Time` is in This Month
`Foster_Animal_Count_Last_Month__c`	Number of `Movements` where `Start Date/Time` or `End Date/Time` is in Last Month
`Foster_Days_Last_Month__c`	Sum of `animalos__Total_Time_Days__c` of `Movements` where `Start Date/Time` or `End Date/Time` is in Last Month

Contact – animalos__Location__c (rollups data from Contact’s related Foster Locations. Depends on animalos__Location__c – animalos__Movement__c rollups)

Field	Logic

Field	Logic
`Foster_Animal_Count_Total__c`	Sum of `Foster_Animal_Count_Total__c` of all related `Locations`
`Foster_Animal_Count_Last_5_Years__c`	Sum of `Foster_Animal_Count_Last_5_Years__c` of all related `Locations`
`Foster_Animal_Count_Last_Month__c`	Sum of `Foster_Animal_Count_Last_Month__c` of all related `Locations`
`Foster_Animal_Count_Last_Year__c`	Sum of `Foster_Animal_Count_Last_Year__c` of all related `Locations`
`Foster_Animal_Count_This_Year__c`	Sum of `Foster_Animal_Count_This_Year__c` of all related `Locations`
`Foster_Animal_Count_This_Month__c`	Sum of `Foster_Animal_Count_This_Month__c` of all related `Locations`
`Foster_Days_Total__c`	Sum of `Foster_Days_Total__c` of all related `Locations`
`Foster_Days_Last_5_Years__c`	Sum of `Foster_Days_Last_5_Years__c` of all related `Locations`
`Foster_Days_Last_Year__c`	Sum of `Foster_Days_Last_Year__c` of all related `Locations`
`Foster_Days_Last_Month__c`	Sum of `Foster_Days_Last_Month__c` of all related `Locations`
`Foster_Days_This_Year__c`	Sum of `Foster_Days_This_Year__c` of all related `Locations`
`Foster_Days_This_Month__c`	Sum of `Foster_Days_This_Month__c` of all related `Locations`

Contact – animalos__Referral__c (rollups data from all Referrals with Record Type = Adoption)

Field

Field
`Adoption_Count__c`	Number of `Referrals` with `Record Type = Adoption`
`Adoptions_This_Year__c`	Number of Referrals where `animalos__Scheduled_Date_Time__c` is 1 year ago or higher
`Adoptions_Last_5_Years__c`	Number of Referrals where `animalos__Scheduled_Date_Time__c` is 5 year ago or higher
`Adoptions_Last_10_Years__c`	Number of Referrals where `animalos__Scheduled_Date_Time__c` is 10 year ago or higher
`First_Adoption_Date__c`	`animalos__Scheduled_Date_Time__c` of the earliest Referral with `Record Type = Adoption`
`Last_Adoption_Date__c`	`animalos__Scheduled_Date_Time__c` of the latest Referral with `Record Type = Adoption`