I want to display webform submitted data in a view. How to recover submissions of my webform in a list?

I think that I can use hook_views_query_alter to change my view's query.

If that's right, how can I implement it?

Any idea please? Thank you!

  • There are couple of default disabled views SITENAME/admin/structure/views and If you don't meet your requirement in the default views then provide more explanations – usmanjutt84 Mar 7 '18 at 13:57
  • In the database, all submissions of the webform are linked to a single node. So when I create for example a project content type and activate the webform above, it only returns a single submission. While I'm trying to display all the submissions in a list – A.Sana Mar 7 '18 at 14:46

you need to add new view 'admin/structure/views/add' and into Show select webform submission continue and edit ... you can get all the submission list into the view.

enter image description here

Add field webform submission data:value enter image description here

Then select webform node and field you want. enter image description here

You can see the fields like this enter image description here

View result enter image description here

So, you can get all fields which you created when you create a web form.

Thank You.

| improve this answer | |
  • Thanks Sir, I tested that but it returns Serial numbers. I need to display all data related to submissions – A.Sana Mar 8 '18 at 12:59
  • Then only set FORMAT as Table and add FIELDS Webform submissions: Serial number (Serial number), Webform submissions: Completed (Completed), Webform submissions: Sid (Sid), Webform submissions: Submitted (Submitted), Webform submissions: User (User), Webform submissions: View link. – AddWeb Solution Pvt Ltd Mar 8 '18 at 13:27
  • You can see the above screenshot as I added new. – AddWeb Solution Pvt Ltd Mar 8 '18 at 13:43
  • Thanks Sir, that's cool but it's not what I am looking to display.. I want to display all data related to submissions => my webform contains many fields (address, phone, country, name...) I want to display this! – A.Sana Mar 8 '18 at 15:46
  • Thnks to ask in detail, I updated my answer you can see and follow after you can get all the submission data. Thank You. – AddWeb Solution Pvt Ltd Mar 9 '18 at 5:26

Yuu can use https://www.drupal.org/project/webform_mysql_views to display submission.

For More info you can visit : https://knackforge.com/blog/sivaji/displaying-webform-submission-data-drupal-views

| improve this answer | |
  • Thanks but it doesn't work with me! I am using drupal 7.56 – A.Sana Mar 8 '18 at 15:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.