Userlist - combining multiple columns

I need to union all some columns before showing them in the list.

Need to have all fields listed under one column in the frontend userlist - I only want to show one column for:

Teacher (cb registration has fields for teacher1, teacher2, teacher3, and teacher4)
Student (cb registration has fields for student1, student2, student3, and student4)

Is there a way to union all the teacher columns and student columns in the comprofiler table before showing them in the userlist?

You can substitute them into a Custom HTML field then display that Custom HTML field on your userlist. See the below on how to substitute fields.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

Your only other option is to use CB Query Field and query for the fields you want and using SQL you can combine them. It's probably easier to just add those fields to a column on your userlist and they'll display 1 after another.

I just utilized the substitution to put city and state together. Very cool

I'm still trying to grasp if I can really utilize the substitution for this specific case though...

If I add a custom html field called cb_allteachers. And include teacher1, teacher2, teacher3, and teacher4. And then add another custom html called cb_allstudents, and include student1, student2, student3, and student4.

I will filter the userlist using cb_allteachers. Keeping in mind that student1 is in teacher1's class, student2 is in teacher2's class, etc. How can I correctly display the student with their assigned teacher? Am I missing something?

What I have currently and what I'm trying to achieve. Hoping this is possible in cb.


Thanks in advance!

If the student is just a field on the teachers profile then just display that student field in a column of your userlist. Sorry, but I still don't understand how you're connecting all of this. Is the student just a text field the teacher fills out? If so there's no issues regarding what student goes where as it's already attached to that teachers profile so you'd just display the field however you like.

The parent completes the form (part of registering on the site). The parent inputs into text boxes each of their students' names and then selects a teacher from a dropdown list - for each student.

On the userlist - I'm trying to filter and display everything by teacher for all registered users (1000+ users, each with multiple students) (seems like I would need to "union all" the data, but not sure how in cb...or if there's another way.).

Do you think I can use substitutions for this? I'm still unclear if I do a substitution for all four of a parent's students, and then filter on the userlist by teacher, how this will keep each student with the correct teacher?

If the teacher is just a select field you don't need to union anything. Just add a Filter to your userlist for the teacher field or set the teacher field as searchable and they'll be able to search for the all students of the selected teacher. If you mean you want to group users together by teacher you'd add an Sorting to your userlist on the teacher field.