Accessing Form Results by User Groups in J3 CF4?

I have a form where there are 4 different type of groups that submit info through a form,
The information gets stored in the database, I have it setup already where:

Each user can bring up their own posted info for each client
There is a Dashboard that has a count for that users submissions
I am able to pull in the logged in users Group name they belong to.

The only problem im having is:
Being able to count the submissions each Group has posted (logged in users group)
Managers of each group being able to see only their "Groups" submissions.

I am using Joomla 3.1 CF4

Hi esl,

Are you using Joomla User Groups here or are they something separate of your own construction?

In either case you can use the WHERE box in a DB Multi Record Loader to filter the results depending on the current User's group membership. If you are using Joomla! groups the coding is a bit more complicated because members can belong to more than one group and you have to allow for that.

Bob

Yes I am using the built in user groups, I will try what you suggested to see if it works , Thanks!

Hmmm couldnt figure out how to filter the results, I keep getting an error

Hi esl,

What filter code are you using?

Bob