Okay, cool.
Another question - when would you want this summary to be generated?
For example, is it something you would expect to have available when you view a Brand Details screen?
Also, the joined_Tags column shown in your Brand Database table - is that via a relation to your Reviews table?
Just want to make sure I have a clear picture of your setup and desired flow.
Yeah, it would be possible.
If I was to do it using JavaScript I’d still take the same approach, but I’d replace about two-thirds of those columns in the Tags table with a single JavaScript column. Essentially, once you have the Joined List of tags, you can pass that to a JavaScript column and do all the work there.
So the input to the JavaScript column would be the jlTags column, and the output would be the same as the ifTagSummary column.
Hey gvalero! Great seeing you here, I actually started with your solution few days ago, I was able to extract counts from my Tags table using relation to Reviews table and a joined list.
But couldn’t quite get the js code to work inside Brands table which is what I wanted. I hope to have individual tag counts for each brand and display them.
Hey @gvalero@Darren_Murphy , also I noticed that inside a collection, if i use Tags as filter, it actually does what I hope. So the function is there, just not sure how to extract it.