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?

Cliff

kbell’s picture

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

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

Lynxas’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

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.

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!