Display certain field values of submissions from multiple webforms in one view

Question

I have two separate webforms, and I want to be able to display all submissions from both webforms that have the same value of a specific field. I also want different fields to be displayed based on what form they're coming from.

For example, both webforms have a field called area. I would like to display the submissions of both these webforms if they both have area set to the same value. Amongst these submissions, if they're from form 1, I want to display the values for field1,field2,and field3 in the view. If they're from form2, I want to display the values for field4,field5, and field6 in the view.

Is there a way to accomplish this in a view?

Answer 1

You may want to read this: https://www.drupal.org/node/2497183

Views cannot display information from more than one webform at a time unless the webforms share the same components.

One solution would be to add order# as a hidden field so that all webforms have a component by this field key. I haven't tried having mixed component types for with the same field key, but I suspect it will work, at least with some view configurations

You may wind up having to create a template for a module to get the report you are looking for.

Drupal answers actually already has a post on this: Multiple Webforms in one View