My site has four webforms. I want to create a view that can display the results of all submissions. Any help please.

Comments

dman’s picture

What have you tried?
Structure : Views : "Add new view" : "Show : webform submissions"

mike_sandes’s picture

Yes, I've tried that, but the only fields I can add are to do with the User, IP Address, submission date etc.
I want to display the contents of the name and address fields , telephone numbers etc. for every submission.

Thanks, dman

p.s. I've also tried a relationship to the sid but I can't get that to work either! (have some experience with views but new to webform!)

twiggit’s picture

I need to do the same exact thing and was very surprised it was not straight forward...

mike_sandes’s picture

I've gone at the problem from a different angle. Given up on the view!

Nicholas Cook’s picture

Hi,

I know it might be a bit late now but maybe this will help others as well...
The module Webform views submitted was a good starting point for me (http://drupal.org/project/webform_views_submitted - D6)
theres a D7 port available at http://drupal.org/node/1219954

tlash’s picture

with the 4.x branch, i was able use native view module to add webform values into a view table. This was great because the webform mysql view, data, and schema modules all together were causing errors and was quite complicated.

Create a new view, and add a Relationship: Content: Webform submission.

Then, in the Fields section, you can add the field: (Webform Submission) Webform submission data: Value

You will then be able choose the field inside the webform that you want to display in your view. You can't sort by these values in a table, but close enough!

trw’s picture

tlash, your answer was just what i was looking for, but i can't seem to get to the last piece. i create a relationship "Content: Webform submission" but then i don't seem to get any new fields, specifically none that show me webform submission data. any thoughts?

cliff98109’s picture

In the configure field window fill out the Webform node field, once you do a Component data selection field will enable you to select any fields in the webform.

Does anyone know how to add filters or sorting to the webform data inside the view?

kbell’s picture

++ I am VERY interested to find an answer to this also!

-Kelly Bell
twitter: @kelly, @gothamdrupal
http://gothamcitydrupal.com

asirjacques’s picture

Why not using entityforms ?

pauln60’s picture

Also, although it's possible to reference the form markup as a component, when you try to use it,
the value doesn't show - not sure if this is a bug or a misunderstanding on my part... either way,
I need to be able to insert some of the form markup. Any suggestions?

Thanks,
Paul

RAWDESK’s picture

I managed to get this exposed filtering on specific submission data fields to work using part of this guidance :
http://othermachines.com/blog/filter-form-submission-data-field-value-vi...
Instead of using contextual filters you can use field filters referring to the created field relation from the webform submission data.
See screenshot

pauln60’s picture

This approach seems to work well - however, for multipage forms with 'page break'
components, the select list for

Configure Relationship: Webform submissions: Data

doesn't show form components except for those on the first and last page.
If the 'page break' components are removed, the select list is complete.
Using webform 7.x-4.0-rc3.

Paul N.

lakenney’s picture

I'm very interested in finding a solution to this question too. "Does anyone know how to add filters or sorting to the webform data inside the view?" I want to filter by 'start date'. In other views I was able to filter by Content: Event Date (>= now) meaning, only show me dates from today forward. But under Add and configure filter criteria I no longer get the option to select 'now' so I get all events.

svorlow’s picture

I'm very sorry - but could you please explain it again? How do I add a relationship? In the relationship menu I see a mask with a dropdown "Kategory" and a field showing "Search". Whatever I do the window closes after pressing "add and configure" (or similar, I just saw it in german language). Could you help me? Best regards, Stephan

eddepetje’s picture

perhaps this can be of any help ? https://othermachines.com/blog/filter-form-submission-data-field-value-v...

I am facing the same problem .If I manage to fix my problem I ' ll let you know how I did it .

TheeBryanWhite’s picture

Question: Do the forms need to be created with Webforms 4 in order to work with this method? I have some forms created with the latest stable release of Webforms but I updated the 4 beta in order to make a view containing submission data and when I'm asked to specify the webform node, I'm told that that "The specified node is not valid".

I can't think of any other reason why this would happen.

NikLP’s picture

Did you find an answer to this? I would very much like to know if there's a workaround that enables updating of a WF3->4 node!

jyve’s picture

You will indeed need Webform 4.0 for this to work.

joshuautley’s picture

God bless the people who take the time to make such great tutorials.

http://othermachines.com/blog/filter-form-submission-data-field-value-vi...

I've done it before but I forgot how to sort by. The link above gives an excellent demonstration!

Josh Utley, President & CEO
Intrepid Network Inc. | Multimedia Services & Business Solutions

"Our mission is to provide a more personable multimedia service along with the highest quality business solutions."

umeshpatil’s picture

Well, this is very long process. But if you are running latest Views and Webform module on Drupal 7 you can do it in just 4 to 5 steps and that too very easily without even installing any extra module.
Just create a new view by selecting webform submissions data and rendered submissions instead of fields under Display format.
Or follow the process from this : - how-display-webform-submissions-views-drupal-7

bib_boy’s picture

If you use tlash's method you can control the values you want from your webform and the labels. By just using rendered submissions you are a bit more restricted. Some help can also be found here: https://www.drupal.org/node/2453023

patricklara’s picture

A very simple way to show the results of Webform is using Webform Report module. You also can try Webform Reports if you need graphical information about the results.

Sarahphp1’s picture

Hi
Here is what I did, but before you follow the below instructions make sure that you have drupal 8.3.x, webforms 5.0 beta or higher and make sure you installed webforms_views module. you can find it here: https://www.drupal.org/project/webform_views
So,
1- Create a new view, and under VIEW SETTINGS choose 'webform submissions', then you can choose the webform you created and wanted to view its submissions from the field: 'type of'
2- Choose the settings you want from page settings .. etc. then hit 'save and edit'
3- under FORMAT under 'show' choose: Fields.. then hit Apply
4- hit 'add' next to FIELDS, now in the window that pops up you should see all the submissions of all webforms you created under 'Category'.
5- In my case, I chose: Webform customer information submission data, and VOILA, all the fields of that sepcific form showed up!

Hope this will help somebody..

bakerlee’s picture

Our webforms require registrants to submit a picture of themselves. When I add it the File field to the view, it shows the file name as a link. How do I make the picture itself appear so we can see the peoples' faces?

RAWDESK’s picture

One option is to overwrite your views-your-view-fields.tpl.php file and put it inside your theme folder.
Lookup your image field, and then render it as shown in example here :
<?php print file_create_url($my_uri); ?>
PS. Make sure you have a uri exposed from the view. If not, there should be a format or rewrite option

Sarahphp1’s picture

choose 'image' under 'Formatter'...
https://ibb.co/gxSgP5

Also, make sure that you chose 'image' under "item format" under 'Submission Display' in your webform's image field.

https://ibb.co/eZDkHQ

v.pathak’s picture

Hello, 
For Drupal 8, is there a provision to add charts to the webform submission data in a view? I used Charts, EasyChart, Views Simple Chart module but I was not able to get graphs working for Webform submission data. I did find this module Webform Analysis (https://www.drupal.org/project/webform_analysis) but I cannot modify the view and place them as blocks.

Any guidance in this matter?

Thanks

Vedang