Install & Customize Grantee Reporting Module
This page covers:
Overview of Amp Impact Grantee Reporting Module
Organizations often utilize Salesforce Digital Experiences to allow grantees to submit regular grant reports directly in Amp Impact. Although organizational processes vary from one organization to the next, there are six basic steps for setting up grantee reporting in Digital Experiences:
Configure Digital Experience Profiles, Permission Sets & Users
Ensure adequate access by cloning or creating profiles and permission sets. This section also includes a few tips to ensure users have the ability to download Performance Graphs.
Set up the Digital Experience Site & Object Pages
Start putting your site together to allow grantee reporting. Typical Amp Impact features to add include Reporting Periods, the Add Results table, Submissions for Narrative Reporting, Performance Graphs, and Financial Reporting features.
Set up the email alert templates to guide stakeholders through the grant reporting process.
Configure Experience Site Profiles, Permission Sets & Users
The personas for each organization will vary depending on their reporting processes and the stakeholders involved. Essentially, you have to start by creating Profiles for the relevant Experience Site access license types as well as the permission sets that will be assigned to the different user groups.
Profiles: You can review this Salesforce article to learn how to create new profiles. Once the new profile is created, scroll toward the bottom of the page to āAdministrative Permissionsā and mark the checkbox next to āAPI Enabledā as TRUE, and de-select all other checkboxes within āAdministrative Permissionsā.
Permission Set(s): You can review this Salesforce article to learn how to clone existing permission sets to modify them for your use case or create a new permission set. The Permissions by Functional Area page provides configuration guidance by feature. Access and permission requirements vary greatly by organization and should be designed based on the use case.
Users: Users can be added to the Experience Site in different ways. Some organizations choose to set up a self-registration process while others control user provisioning internally (Salesforce Documentation). Most users already exist in the Experience Site to enable grant reporting since they were added when they initially applied for the grant. When creating Experience Site Users manually, here are a few gotchas to consider:
Any Contact that should be enabled as an Experience Site user, should be associated with an Account record.
The Owner of the Account must be associated with a role in the Role Hierarchy to enable Experience Site users.
Profiles are assigned when the user is created but permission sets are added once the user is already created. Typically, the āAmp Impact Communityā permission set is also assigned to allow access to the relevant Amp Impact objects.
To allow Digital Experience users to download and export Performance Graphs successfully, an additional step is required for setup:
Navigate to the Setup Interface and search for āCSP Trusted Sitesā to add a āNew Trusted Siteā.
4. On the next screen, ensure the following fields are populated, and click āSaveā:
a. Trusted Site Name: HighchartsExport
b. Trusted Site URL: https://export.highcharts.com
c. Context: All
Set Up The Digital Experience Site & Object Pages
After setting up Digital Experience profiles, permission sets, and users, admins can now set up the Lightning Digital Experience using Lightning components. Salesforce offers extensive documentation on setting up Experience Cloud depending on your use case.
After configuring the Digital Experience, funders can set up Reporting Period records and invite grantees to report their results for specified time frames. Grantees can fill out reports including adding results, visualizing targets vs. results, narrative reporting, and financials. To learn more, view the Grantee Reporting User Guide.Ā
Set Up Reporting Periods
Click on User profile icon on the top-right corner. From the dropdown, select āExperience Builderā.
Click āNavigation Menuā button. Another popup will appear.
Click ā+ Add Menu Itemā button.Ā
Name Menu Item as āReporting Periodā, select Type as āSalesforce Objectā, and select Object Type as āReporting Periodā. You can leave the Default List View at āDefaultā.
Click āSave Menuā.
Create a Reporting Period record page in the Digital Experience Builder.Ā
Click the dropdown in the top left corner.
Scroll to the bottom of the Picklist and click the ā+ New Pageā button. A pop-up will appear.
Select āObject Pagesā.
Find and select āReporting Periodā in the list of Objects.
Click āCreateā. You will be navigated to the new Reporting Period Detail Page.
On the Reporting Period detail page, click on the āComponentsā icon on the left-hand navigation panel, as shown in the screenshot below.
Search for the āTabsā component. Drag and drop it between the Record Banner and Content Footer. See below for a screenshot.
If desired, click āPreviewā to review changes before clicking āPublishā to save.
Set Up Add Results
Navigate to Digital Experience Builder on Reporting Period object.
Click on the Tabs editor on the right-hand side and add a new tab.Ā
Click on the new tab and rename it to āAdd Resultsā, as shown in the screenshot below.
Click āSave.ā
Add a Visualforce Page component to the Add Results tab.
Find the Visualforce Page component in the Custom Components section of the list, see the screenshot below.Ā
Drag and drop the Visualforce Page component above the footer.
A pop-up window will display on the right-hand side. Select AddResults from the dropdown for the Visualforce Page Name. All other fields should be left alone.
If desired, click āPreviewā to review changes before clicking āPublishā to save.
Set Up Narrative Reporting
Ensure steps from Set Up Add Results have been completed.
Click on the Tabs editor on the right-hand side and add a new tab.Ā
Click on the new tab and rename it to āNarrative Reportingā.Ā
Click āSaveā as shown below.
Add the SubmissionResponseForm component to the Narrative Reporting tab.
Find the SubmissionResponseForm component in the Custom Components section of the list.
Drag and drop the SubmissionResponseForm below the Record Detail component.
If desired, click āPreviewā to review changes before clicking āPublishā to save.
Set Up Performance Graphs
Ensure steps from Set Up Add Results and Set Up Narrative Reporting have been completed.
Open up the tab editor, and click Add. Edit the tab name to āPerformance Graphsā.Ā
Click āSaveā as shown below.Ā
Add a Visualforce Page component to the Performance Graphs tab.
Find the Visualforce Page component in the Custom Components section of the list.
Drag and drop the Visualforce Page component above the footer.
A pop-up will display on the right-hand side. Select Performance Graphs from the dropdown for the Visualforce Page Name. Leave all other fields same.
If desired, click āPreviewā to review changes before clicking āPublishā to save.
Set Up Financial Reports
Navigate to Digital Experience Builder on Reporting Period object.
Click on the Tabs editor on the right-hand side and edit the name to āFinancialsā.Ā
Click āSaveā as shown below.
Add the āRecord Related Listā component to the Financials tab.
Search for the Record Related List component in the Components section of the list.
Drag and drop the Record Related List component where it says āFinancialsā in italics, right above the template footer.
If desired, click āPreviewā to review changes before clicking āPublishā to save.
Activate The Digital Experience Site
After successfully setting up the Digital Experience with users, be sure to activate the Digital Experience and add Members to the site to ensure the right profiles are granted access.Ā
Set up Emails for Grantees to Access Reports
System administrators can configure an email alert to send grantees the link to a grant report according to the start and end dates.
Create an Email Template
Navigate to Setup, and search for Classic Email Templates using Quick Find.
Click on New Template, and refer to the screenshot below.
In Step 1, select Custom (without using Classic Letterhead), as shown in the screenshot below.Ā
In the Email Template Name, input āRemind Grantees to Reportā. Template unique name should auto-populate to āRemind_Grantees_to_Reportā.Ā
Input the subject line.Ā
Below is a suggested template, and users can additionally customize it per your organizationās needs. Be sure to specify Reporting Period and Community link using merge fields.Ā
The below text is for HTML formatting:
<p>Dear Grantee, </p>
<p>Please treat this mail as a reminder to submit your results and report for <b>reporting period: {!ampi__Reporting_Period__c.ampi__Label__c} </b></p>
<p>Please go to the following link to submit your report:Ā
https://sandbox-app-energy-6958-dev-ed-16cb293fa53.cs78.force.com/test/s/detail/{!ampi__Reporting_Period__c.Id} </p>
<p>If you are facing problems in accessing the above link, kindly contact system admin. </p>
<p>Regards, </p>
<p>Grant Maker</p>
Ā
8. Complete the plain text version of the HTML email.
a. Remove HTML markup including <p></p> and <b></b>.
9. Return to Setup.
10. Using Quick Find, navigate to Email Alerts.
11. Create an email alert using the email template and specify contacts (Salesforce/External) to whom the email should be sent, shown in the screenshot below.
12. Click Save.
Configure Email Automation
Now that the email template and alert are set up, system admins will need to configure the email trigger and automation, known as Process in Salesforce.
From Setup, navigate to Process Builder through Quick Find.Ā
Click New. A pop-up will appear.
Input āSend grantee report emailā under Process Name.Ā
Under the dropdown, select that this process starts when āA record changesā. Click Save.
Right under start, click on + Add Object.
In the Object dropdown, select Reporting Period. Start the process āonly when a new record is createdā, as shown below.
From Reporting Period, set criteria for an action group as shown below.
Set the immediate action to follow if RP is created==āTRUEā.
Set up an email alert to notify grantees 10 days before a reporting period.
Using the Time Lapse feature of Process Builder, set the immediate action to Email Alerts using the dropdown.
In Action Name, input Remind Grantees to Report. The Email Alert name is Remind_Grantees_to_Report, as shown in the screenshot below.
Schedule the EmailĀ
Ensure steps from Configure Email Automation have been completed. Remain in Process Builder.
Set a scheduled action to trigger the immediate action 10 days before the end of a Reporting Period.
Click Save.
Double-check that your process builder looks like the screenshot below.
Add another scheduled action for email trigger under the scheduled action, as shown below.
6. Click āActivateā.
Ā