Hi, I’m new to Airtable. I am working on a project that will require automatic sorting and grouping of registrants. Below is an example of my problem.

- An event is created by a host and sets is a limit to the number of participants in a class
- Users register for an event.
- On the day of the event, the host verifies attendance, and the classes that exceed the limit must be divided into heats. (this is intended for a competition)

How do I do part 3?

I envision a way to divide groups that exceed the limit until the groups are below the limit. But, I don’t know the best way to do this.

Limit = 5

In attendance = 34

In this example, I am left with 6 heat of 5 and 1 heat of 4. This is good.

Limit = 5

In attendance = 36

In this example, I am left with 7 heat of 5 and 1 heat of 1. This is bad. One person in a heat isn’t much of a competition.

Aside from the math, I’m not sure that this can be done in Airtable.

Any suggestions?