I’m trying to do the latter (may not even be possible now that I think about it)
1 Like
I don’t think there is a way to count multiple matches in the same row.
Got it - okay that’s helpful for me to close the loop and stop chasing it. Really appreciate your help here Jeff and David as well!
1 Like
Technically, you still could, but you would have to set up a relation for each search query separately. I don’t think that would work with split text though, since you can’t single out each item in the array. It would probably require separate entry componts for each search query word, separate relations, and separate rollups on each relation. Gets a little messy.
1 Like
I’m having this same issue. In my case, I’m trying to match siblings.
I built a relation that relates children when they share the same parent name. The issue is that every row’s parent name matches the same row’s parent name, in addition to any subsequent row. So what ends up happening is each kid shows one sibling (self) in addition to any other.
How would I remove the relation to self, leaving the true sibling relation (say, in an inline list)?
Is this just for a count? You could create a math column that always subtracts 1 from the count.
1 Like
Hi
Not sure if this helps, but I just achieved exactly this.
A comments table for another table of “issues”
In my “Issues” table - I have a relation back to the comments table - using the Row ID
I then had a roll up field set on the Relation field set to count the values of that related field
Screen shot attached.
Hope that helps.
Andrew
1 Like
The relation columns don’t appear as an option for the rollup field type when I try and attempt this strategy in my database.
Never mind. I figured out what I was doing. I finally noticed that my relation column was appearing at the top of the list when setting up the rollup. I kept choosing the table to locate the relation column.
1 Like