Custom Form Reporting | Community
Skip to main content
Halie_Baer
New Participant
August 2, 2024
Solved

Custom Form Reporting

  • August 2, 2024
  • 1 reply
  • 892 views

Overview: I would like to be able to pull a report showing the answers to certain fields on a custom form 

 

Background: We are an in-house marketing department. We get requests from several places (dealers, sales team members, and internal departments). I've created fields on the custom form we use for requests to distinguish where these requests are coming from. Now we'd like to start auditing when and where our requests are coming from throughout the year by building a dashboard with reports. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Madalyn_Destafney

This can easily be done. Are the fields you want to track on all of the various request/issue custom form(s) you're getting from the various groups so you can compare apples:apples? Even if not, you can work with native fields to show # of requests from the different groups MoM for example. You'll want to work with an issue report since you're looking at requests (assuming you're using request queues for these folks).

 

You can do an issue report grouped by project (i.e. queue), and have columns for any of the custom fields you want to show, as well as when the request was submitted, by whom, etc. Plenty you can do here!

1 reply

Madalyn_Destafney
Madalyn_DestafneyAccepted solution
New Participant
August 2, 2024

This can easily be done. Are the fields you want to track on all of the various request/issue custom form(s) you're getting from the various groups so you can compare apples:apples? Even if not, you can work with native fields to show # of requests from the different groups MoM for example. You'll want to work with an issue report since you're looking at requests (assuming you're using request queues for these folks).

 

You can do an issue report grouped by project (i.e. queue), and have columns for any of the custom fields you want to show, as well as when the request was submitted, by whom, etc. Plenty you can do here!

If this helped you, please mark correct to help others : )
Halie_Baer
New Participant
August 2, 2024

Hi Madalyn, 

This doesn't quite cover it because we have coordinators that fill out the request forms on behalf of the requestor. For example: 

Issue: Project X 
Submitted by: JANE DOE 
*Custom Field: Requesting Department  

*Custom Field: Requestor Name 
    *These being the fields I would like to pull reports on 

Madalyn_Destafney
New Participant
August 2, 2024

You can still do this depending on the format of those 2 custom forms. If the department is a single-select dropdown or radio buttons, you can group the issue report by that custom field instead of by project name. Same with requester, if it's a typeahead field, you can group by that custom field. If both are text fields, you won't be able to group by them as easily (if any variation in how people write these in you'll get inaccurate groupings) but instead can have columns for those 2 fields and sort by them to still group them together within the report.

If this helped you, please mark correct to help others : )