Recent Updates
-
Updated on: Jan 17, 2023
Using views to update organizations, contacts and connections
-
Updated on: Jan 17, 2023
Uploading Users into HandsOn Connect Using the Apex Data Loader
This lesson assumes that you have already imported contacts into the system for the users that you wish to create and that you have already set up the Apex Data Loader.
-
Updated on: Jan 17, 2023
Bulk Uploading Connections with the Apex Data Loader
The Apex Data Loader is currently the only way to bulk upload Connections into HandsOn Connect. This walks you through connecting a list of Contacts to a specific Occurrence. The tutorial assumes that you have basic knowledge of Salesforce reporting and that you have set up the Apex Data Loader.
-
Updated on: Jan 17, 2023
Counting the number of object records in a report
HandsOn Connect has hidden fields that allow you to easily count the number of objects in a report.
There are "number of" fields for:
- Number of Contacts
- Number of Organizations
- Number of Connections
- Number of Occurrences
- Number of Volunteer Opportunities
For example, in a report that shows all the occurrences that took place in a given time period, you could group the occurrences by the volunteer opportunity name -- but what if you wanted to know how many volunteer opportunities that represented?
Manual Reports and Dashboards -
Updated on: Jan 17, 2023
Working with Numbers - Sums, Averages, Min and Max
Number fields can be summarized so that you are able to see summaries of numeric information --
Manual Reports and Dashboards -
Updated on: Jan 17, 2023
Views vs Reports
So far we've talked about "Views" as a way of looking at multiple records of data at once.
But Views have limitations.
The deepest view of data is found in reports.
What are the differences?
Manual Reports and Dashboards -
Updated on: Jan 17, 2023
Report Folders With Special Characterisics
Manual Reports and Dashboards -
Updated on: Jan 17, 2023
(Advanced) Report Types recommended for use in your reports
When selecting report types - you can choose from standard report types created by Salesforce, custom report types you create on your own, or these special report types we've created for maximum flexibility with HandsOn Connect.
Manual Reports and Dashboards -
Updated on: Jan 17, 2023
Video: Data Bucketing
Data Bucketing lets you quickly categorize report records without creating a formula or a custom field. When you create a bucket field, you define multiple categories (buckets) used to group report values. For example, create a bucket field named Size based on the # Employees field. Then, create buckets that group records into “Large,” “Medium,” or “Small” ranges that you define. Bucket fields can be used like any other field to sort, filter, and group your report.
Manual Reports and Dashboards -
Updated on: Jan 17, 2023
(Advanced) Using cross-filters in a report
Use cross filters to filter a report by an object's child objects using WITH or WITHOUT conditions. For example, filter a report to show just accounts with cases, or contacts without activities. You can apply cross filters by themselves, or in combination with field filters.
Note that filter logic applies only to field filters—not cross filters. You can create up to three cross filters per report.
Add subfilters to further filter by fields on the child object. For example, if you have a cross filter of Accounts with Opportunities, click Add Opportunity Filter and create the Opportunity Name equals ACME subfilter to see just those opportunities. You can create up to five subfilters for each cross filter.
Manual Reports and Dashboards