View and export a comparison of responses across multiple intake form entries.
The response comparison tool allows responses across multiple intake form entries to be compared on one page. The Response Comparison tab is available when viewing data for a specific intake form on the grantee portal intake form dashboard. This is often used when completing an internal review of submitted intake forms.
Data collected in standard fields cannot be imported into GivingData, so this data cannot be accessed via a super search, a report, or through other features or functionalities. The response comparison tool allows responses to standard fields to be compared across multiple applicants/grantees.
Article Sections
Navigate to the Response Comparison Tool
Navigate to the Response Comparison Tool
Follow the steps below to navigate to the response comparison tool for an intake form.
- Click Dashboards in the upper navigation bar, and then click Grantee Portal Intake Forms.
- Click the intake form type.
- Click the intake form name.
- Click the Response Comparison tab.
Edit the Response Comparison List View Columns
After navigating to the Response Comparison tab, the columns in the list view can be edited to display the desired data. For additional general instructions on editing list view columns, refer to Editing Columns in Super Search Results.
To retain the selected columns after logging out and back into the site, configure the default list view as detailed in How to Edit Default List Views.
- Click Edit Columns.
- Click View All Columns.
- Check the box for each field to display as a column in the list view, and then click OK.
- The Intake Entry Responses tab contains each field on the intake form. This includes both mapped and standard fields.
- The Intake Entry Properties tab contains other request record fields that can be added to the list view.
- Click Update.
Due to technical limitations, the following fields cannot be included as columns in the response comparison tool:
- File Uploads
- Demographics via Candid
- Editable Codes
- Bank Account
- Financial Data By Year
- Assessment Sources
- Organization's Self-Assessment
- Fields from a Contacts Page
Use the Response Comparison Tool
Once the list view columns have been edited as desired, the intake form data is visible on the page.
- Text area fields retain any HTML formatting from the intake form.
- Intake form fields with a checkbox display "Yes" if the box was checked, and "No" if the box was not checked.
Click Export to Excel to export the list view data.
- If more than 10 columns have been added to the list view, it is recommended to view the results by exporting to Excel.