Generate a page that lists all of the data entered into a CB field

On my profile page, I have entries for college(s) attended: undergraduate, graduate, postgraduate. I want to have a page that dynamically summarizes in list/table format all of the colleges which are entered into those three fields. Perhaps add the number of entries for that particular school. The school listing is clickable to retrieve a listing of users who attended the school that was clicked upon. Similar to what is accomplished using the CB Search plugin. Any suggestions as to how this may be accomplished with existing CB plugins, or some third party solution that I could purchase to perform this task?

Not sure I understand what you're trying to accomplish. You want a list of fields of users? That's exactly what a Userlist is, which you can create within CB > List Management. If you want to format multiple fields output into a single formatted field you can use a delimiter field and substitutions. Please see the below tutorial regarding substitution usage.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

Hi Kyle --

You misunderstand.

The school(s) attended by the user is a text input field(s). I want to generate a list of the schools that have been entered, and indicate the number of users who have entered that school. This is in addition to the standard CB User List. An example of what I have in mind -- in tabulated format:

The schools attended by our members
Click on the School name (or number of member attendees) to view the list of members who attended that school

School Undergraduate Graduate Post-Graduate
MIT (20) (15) (10)
Stanford (30) (22) (18)
Yale (41) (12) (5)
...
...
...

Thanks for your help

That's possible with database queries, but I've no idea where you intend to display that. Do you want it shown on every users profile? It can be done using CB Query Field as it can query the database for such information, but that's really only if you want to display it on the users profile.

Hello Kyle --

The list would appear on a separate page or perhaps within a module.

The situation occurs when a user wants to search for website members who attended a specific school. The user should be able to access a list of the schools that are recorded in the database, so that he avoids an empty search.

Perhaps the solution is to have a CB Query Field that is activated by clicking on a link -- eg, "See the list of schools our members attended". When clicked, it opens a new page (or popup), performs the search, then displays the results. The user can then enter the name of the school in which he is interested into the general search form to find those members. Better yet would be for the user to be able to click on the school name to generate the list of members.

Is my scenario explanation clear? I do ramble a bit.

Thanks for your help.

I suggest creating a CB Userlist within CB > List Management for each school. You'd then just add a Filter to each school specific list to filter the users down to only the users that belong to that school.