By hondaman900 on

Seems like this should be simple, but I have several entityForms and want to create a view that shows a column from each of two entityForms. I have no issues creating views from the submissions of a single entityForm. I've searched extensively and can't find a solution.

I create a view based upon entityForm submissions. To show my field column I have to filter by entityform submission:entityform type. If I add the other entityForm type to the filter, that of course restricts rather than expands my data scope.

I need to display column A and column B from entityForms Submissions where entiityForm Type can be either entityForm A or entityForm B.

Any suggestions as to how I can do that? I can use attachments but that doesn't achieve my goal as the results are then separated into different sections.

Using D7.5 & Views3

⋅ Categories: Drupal 7.x

Comments

hondaman900’s picture

hondaman900 commented

Any suggestions....?

hondaman900’s picture

hondaman900 commented

Well, to answer my own question...

I was able to do this by creating a view that included all entityForm submissions, creating columns for all the fields I wanted to sum together, hiding them and then using a Views GlobalPHP field to output them into one combination column of all those fields. The PHP, whose scope is limited to just that row, will pull in the field that shows in that row across the many columns. In this way the GlobalPHP pulls in all the fields into one fully-populated column of all the aggregated fields I needed to sum.

Hope this helps someone else down the road...