1

I am currently stuck trying to build a view wich contains a simple list of webform's name not submitted yet by the current user so that the current user can only see a list of webforms to be filled. How can this be accomplished?

I experimented a lot of settings but i couldn't get the expected result. Any help would be much appreciated

  • Interesting challenge "also" (apart from your Forena question I just answered). Maybe use Forena for this also (after you got it to work for your other answer)? – Pierre.Vriens Feb 22 '17 at 19:52
  • i will try to use forena as you suggested Pierre. I will describe here how i did it if i succeed. – HusterFrancis Mar 2 '17 at 9:53
0

I'm not sure if there is a solution to create such kind of view using the Views module. But the Forena module (disclosure: I'm a co-maintainer) can be used for this type of reporting. More specifically by using its facility to create a Display of a table in crosstab format.

A crosstab table is a table with a special layout. It is formatted as a grid, with:

  • the rows representing one or more (combinations of) facts, such as countries or regions, names of persons (or users) like employees / salespeople (or user IDs / user names), etc.
  • the columns representing one or more other facts, such as periods (months of a year, years, etc), available types/flavors of something (like types of errors), etc.
  • the intersections of rows and columns containing the actual information (data), such as summarized information (counts of something), timestamps, etc. and which might (optionally) include a hyperlink to a drill-down report.

Below is a sample of such crosstab report (including drilldown links also, i.e. the numbers in red in it):

enter image description here

Refer to my comment in the Forena issue queue for more details about the above screenshot. And/or have a look at the video about How to generate crosstab reports with graphs (Forena also supports charting of those data, a typical related requirement ...).

Specific to your question here, I'd create such table in crosstab format with rows/columns like so:

  • The rows should represent your users (1 row for each user).
  • The columns should represent your webforms (1 column for each webform).

With such setup, the answer to your question is then contained in the intersections of all rows and columns that are shown as "blank" (= zero submissions of the specific webform by the specific user).

PS: I'm assuming you're using D7 ...

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.