Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Tally the amount of “x” in a row?

154 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi -

So we are a camp and I’m trying to tally the amount of children attending a certain week. In AT they have 1-8 or Full listed as their enrolled sessions all as a multiple select choice. How and where can I have tally’s as so how many in that specific group are coming weeks 1, 2 and so on?

3 Replies 3

Hey @Todd_Robbins!
Welcome to the community!

There are a couple of ways to approach what I believe you want to accomplish.

Your single most significant limiting factor in what you’ve described is the usage of the multiple-select field.
With your current data structure, you’ll probably want to rely on the Summary, Pivot Chart, or Chart extensions to provide you with a quick, high-level glance at your data.

For what you’re looking to do, I would recommend you make a few tweaks to your data structure.
Here’s how I might approach your use case…

I created a demo base for this post. If you’re curious to poke around for yourself, here’s a link to it.
Feel free to duplicate the base into your workspace and use it if you’d like


From what you wrote, you have two simple types of data: the children attending, as well as the actual weeks themselves.
This means that we’d want two separate tables for our data.

I’m a bit bored tonight, so here’s an example I built:

image

The attendee data is programmatically generated.
I went ahead and generated 100 random records.

image

Then, I created a linked record field between the Attendees and the Camp Weeks tables.
From there, I went ahead and linked a random number of attendees to the different weeks.

That ends up looking like this:

image
image

It’s kinda ugly as is, so we can use lookups, counts, and rollups to format our data to a more readable format.
Using a rollup field, I can summarize how many attendees are signed up for a single week:

image

Now that we have this structure built, we can also start to account for scenarios where an attendee might be going for multiple weeks.

image

This schema design allows me to summarize more specific data points such as how many attendees are signed up for multiple weeks.

image

There is some cool stuff you can do once your data model has a strong foundation.
It’s really up to you at that point.

Thanks Ben!

I’m going to look into this later but I just read through your response. Is there a way to view this in the kanban view?

Todd

Since a kanban requires the existence of either a collaborator or single-select field, then this current structure makes it impossible to do so.

If you want to view the data in a ‘kanban card-like’ view, then a Gallery view would be my recommendation, as seen below:

image