Hi there. I am working with a Rollup up field linking between a Series table and ID table. The ID table has a field called Episodes. What I am trying to work out is how do I display the number of episodes linked from the linked ID table and the count of each.
Example:
Episode Roll Up
9, 5, 3, 3
(so there are four ID records linked to the Series table and from the ID table’s Episode field there is 1 x ID from Ep 9, 1 x ID from Ep 5 and 2 x IDs from Ep 3)
What I would like to display either directly in the RollUp field or in a companion Calculation field is the following:
3: 2
5: 1
9: 1
(so I’d like to be able to order the Episode numbers as well to make it cleaner to view).
I have searched thru the Community posts but can’t find anything that addresses this particular query. Any help would be very much appreciated!
