Help

Re: Sum total number of participants on a given date with specific product

308 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Elizes_Low1
4 - Data Explorer
4 - Data Explorer

Hi, in the grid view, I am able to group fields and have the total count or sum of each columns. How can I apply that to calendar or gallery view?

(upload://me7xtvwKic1c9D1iCnw4ltO6Ew.png)
I am operating a tour agency where I have a trip ID, date of the trip and number of participants. However, participants can register for each trip randomly on any date. How can I add the number of participants that is taking part in trip A on 1st of April for example?

Thank you in advance for helping.

1 Reply 1
Mike_McLaughlin
8 - Airtable Astronomer
8 - Airtable Astronomer

As one possible method to do this, I’d suggest having the trips in one table and the people registering for it in another.

You’ll want to setup a ‘link to another record’ field in the registrations table that references the trips table. (when creating a new registration, you’ll add the trip a person is going on as a linked record with this new field)

Then in your trips table, there will be a new field that has a list of everyone going on that trip. You can automatically count the number of people in that field if you use a new ‘count’ field.