So I see that we can use connection fields for numerical aggregations (Sum, Min, Max, Average, Count), but I was wondering if there’s some way to do the same with text.
For example, let’s say I have a Students table and a Classes table, and a connection so that each Student record has a connection field to a Class record. Now in the Classes table I know we can use the Count aggregation to show how many Students are connected to a specific Class record. But what if I also want a text field to display a list of these connected students’ names? Ideally just like Sum for numerical values, I could concatenate text values with a separator, so we get “John Smith, Jane Doe” etc.
(another example, each Student record has a text Feedback field, and we want to see a combination of all Feedback fields for each Class record, etc.).
Hi @Crumbs,
This can be achieved natively. You can add a connected table’s field to a view, and display each record on a separate line or comma-separated.
For example, in a Classes grid, you can add a connection field to show the names of each connected Enrolment record, and then make it comma separated.
Sorry I’m not sure I understand. I’m still using the Next-Gen version because Knack team hasn’t gotten back to me about the toggle to Classic.. so I couldn’t find where your screenshots are taken. I’ll clarify with an example, and please let me know if your solution is suitable:
Let’s say I have a Classes table:
record 1 - class name = A
record 2 - class name = B
and a Students table:
record 1 - name = John, class = connection to class A
record 2 - name = Jane, class = connection to class A
record 3 - name = Judy, class = connection to class A
record 4 - name = Bill, class = connection to class B
Currently I know I can add a Count aggregation to Classes, so it will show:
record 1 - class A, count 3
record 2 - class B, count 1
But ideally I’d also be able to add a textual aggregation of the student names:
record 1 - class A, connected students = (John,Jane,Judy)
record 2 - class B, connected students = (Bill)
It looks like the feature is broken in Next-Gen, but works in Classic. Might need to log a ticket. @Kara FYI - Is this related to those current changes you mentioned?
