Jump to content

Questionnaire- Report on responses


Adnan Zamurred
 Share

Recommended Posts

Hi there, 

I've built a questionnaire form consisting of 55 questions which staff members will complete annually. Is there a way to report on what responses are given to each question e.g. I want to see how many employees answered yes to a specific question. As there are 55 questions, there's not enough custom fields I can use, is there any other way? I've labelled the field ID to each question in the procap as the question number e.g q44

 

 

Link to comment
Share on other sites

Hi @Adnan Zamurred

It is possible to report directly on answers to Progressive Capture questions without needing to map them all to custom fields. The answers are all stored in the table h_itsm_questions and this contains information such as the Form ID and Question ID as you have referenced above. If you were looking at Date Criteria as well, you would need to perform a join with the main request table (h_itsm_requests). 

If you need further assistance, we would need some more specific details about the type of report you were looking to run (e.g. what would you expect the output to look like,  specific criteria you are measuring, if there is any grouping, date range etc)

This is an example of the type of date stored in h_itsm_questions:

Screenshot_30.png

 

Hope this helps,

Kind Regards

Bob

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...