Help

Votes Name Aggregation (sum of unique string values from 1 - 3 columns)

Topic Labels: Data Interface Designer
Solved
Jump to Solution
137 3
cancel
Showing results for 
Search instead for 
Did you mean: 
aanders50
4 - Data Explorer
4 - Data Explorer

Hello! I am new to Airtable and have been poking around for awhile now to try and create the following / see if it is possible in Airtable.

Overview
I am setting up a super simple voting table, it will just have an ID and 3 string vote fields

I.E. test data, and/or the Votes table, would be like (made-up names used)

IDVote 1Vote 2Vote 3
582394John DoeSally Sue (blank)
362344Billy JoeJohn DoePeter Thol
623442John DoeBilly JoeSally Sue

Which ideally would aggregate into this Votes Cast table, sorted greatest to lowest number of votes:

NameVotes
(aggregated from above based on string value)
John Doe3
Sally Sue2
Billy Joe2
Peter Thol1

At first I was reading about Rollups, but I am not seeing examples utilizing multiple fields/and or creating dynamic lines for results, for example, if a new person submitted the name James Cullen, then a new row would appear about for James Cullen with their 1 vote.

If this is not possible...
is there a way to achieve this if I do 1 vote per row? I.E. If each vote (of three) cast generated 1-3 rows, such as

IDVote 1Vote 2Vote 3
582394John DoeSally Sue(blank)
362344Billy JoeJohn DoePeter Thol
623442John DoeBilly JoeSally Sue

becoming.. (1 vote per row)

IDVote
582394John Doe
582394Sally Sue
362344Billy Joe
362344John Doe
362344Peter Thol
623442John Doe
623442Billy Joe
623442Sally Sue

Would this approach work to achieve my goal?

Any help appreciated, I would be filling in the Votes table's data from Zapier as well and ideally instantly or hourly aggregating the results as new Votes rows come in..

Thank you!

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, if you're okay with adding a new table for this where each record represents a single person, then you could do this:

Screenshot 2025-02-04 at 7.56.53 AM.png

Screenshot 2025-02-04 at 7.58.15 AM.png

And I've set it up for you here!

See Solution in Thread

Does this allow for new Candidates to be added on the fly without the need to add additional logic?

Yeap it should!

---
Very last question, are there any hard limits on the number of these linked/related vote

Not that I'm aware of!  I've had a single record linked to thousands before and it was fine

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, if you're okay with adding a new table for this where each record represents a single person, then you could do this:

Screenshot 2025-02-04 at 7.56.53 AM.png

Screenshot 2025-02-04 at 7.58.15 AM.png

And I've set it up for you here!

Very cool! Does this allow for new Candidates to be added on the fly without the need to add additional logic? Like if a brand new user did a write-in vote for "Bob P", when I have Zapier add a new row into Table 1 such as 1234 | Bob | John Doe | Billy Joe, will the Votes table automatically add a new row for new string value of "Bob P" with 1 vote? 
I am hoping once I have it all setup I can just make a dashboard interface and leave it at it until the voting process is done.

Very last question, are there any hard limits on the number of these linked/related votes (outside of various AirTable plans)? I think I need to be able to support 2-3 thousand votes per candidate at most (as there are 2-3 thousand voters total). 

Thank you very much!

Does this allow for new Candidates to be added on the fly without the need to add additional logic?

Yeap it should!

---
Very last question, are there any hard limits on the number of these linked/related vote

Not that I'm aware of!  I've had a single record linked to thousands before and it was fine