Create a Report on form Submissions

SHANE EBERT asked on April 10, 2017 18:36

Hello,

I am trying to utilize Kentico as a "Survey" tool like Survey Monkey by using the form builder. I have no problem creating the forms, and getting submissions.

The problem is sharing the results with my team. I would want to create a report for each form and their results. How would I create a report for this? I am in marketing and not good with code.

Report Requirements:
- Show all individual responses

Thanks

Recent Answers


Brenden Kehren answered on April 10, 2017 18:52

VS creating a report, why not just export the results from the data? This is already supplied out of the box by clicking on the hamburger menu in the listing of "Recorded data" under the form. Click the menu and select the format you want and uncheck the "Current page only" and click export. Will get you all of what you need in a file.

If you must create a report, check out the documentation for creating a report.

0 votesVote for this answer Mark as a Correct answer

SHANE EBERT answered on April 10, 2017 19:06

Thank Brenden,

I am aware that I can export the data. The main reason is I want to make it automated, I prefer not to export the data and share with the team everytime there is a new submission. I will take a look at the documentation.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on April 10, 2017 19:09

Another option to creating a custom report is creating a custom query which selects all from the table and displaying that data on a "secure" page where the users have to log into. Your query might look like this:

SELECT * FROM Form_YourCustomTable ORDER BY YourColumnName

You'd get the table name from the form's definition. You can also use this query to create a report with too.

1 votesVote for this answer Mark as a Correct answer

Rui Wang answered on April 10, 2017 19:27

I agree with Brenden, it all depends on the UI you want for this report. As a private page or as an App page.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.