- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 07:40 AM
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)
ID | Vote 1 | Vote 2 | Vote 3 |
582394 | John Doe | Sally Sue | (blank) |
362344 | Billy Joe | John Doe | Peter Thol |
623442 | John Doe | Billy Joe | Sally Sue |
Which ideally would aggregate into this Votes Cast table, sorted greatest to lowest number of votes:
Name | Votes (aggregated from above based on string value) |
John Doe | 3 |
Sally Sue | 2 |
Billy Joe | 2 |
Peter Thol | 1 |
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
ID | Vote 1 | Vote 2 | Vote 3 |
582394 | John Doe | Sally Sue | (blank) |
362344 | Billy Joe | John Doe | Peter Thol |
623442 | John Doe | Billy Joe | Sally Sue |
becoming.. (1 vote per row)
ID | Vote |
582394 | John Doe |
582394 | Sally Sue |
362344 | Billy Joe |
362344 | John Doe |
362344 | Peter Thol |
623442 | John Doe |
623442 | Billy Joe |
623442 | Sally 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!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 03:59 PM
Hmm, if you're okay with adding a new table for this where each record represents a single person, then you could do this:
And I've set it up for you here!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 05:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 03:59 PM
Hmm, if you're okay with adding a new table for this where each record represents a single person, then you could do this:
And I've set it up for you here!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 05:13 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 05:51 AM
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
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)