How find the Thing with most links/relations to another Thing

Need help
1

I have two tables. One with Competitors and one with Voters. Voters have a reference to the Competitor they voted for. I need to find the Competitor with the most Votes. Not a db expert, so can’t seem to crack this :blush:

2

Honestly, it would be easier to keep a number field on the Competitor. Every time a new voter votes, make a change to Competitor > votes field = this Competitor’s votes field + 1

3

Yes, but it requires me to keep track of when and where the counters should be changed (more than one place), which is a bug inducing risk. Is this Do Search possible in Bubble?

4

@romanmg is right, that will be the easiest way.

You could probably fudge something together with a temporary table and api workflows… But that will be slower and probably more complicated.

5

Ok. Temp tables sound error prone. Counter it is. Thanks.

6

This topic was automatically closed after 70 days. New replies are no longer allowed.