How to Set Capacity Limits for Reservations

Hello, I am trying to create an app for training classes and have limits on the number of people who can sign up for the class. Once the class is full I do not want it to show up as an option anymore for people to sign up.

I am thinking a filter on a list of classes might work but can’t figure out how to get the total number of signups already paid for on that particular class.
Screen Shot 2021-06-06 at 6.50.13 PM

Does anyone know how to do this or have an alternative way of doing this? Thank you!

@djamison you can disable the signup button when the total registration count is equal to or greater than the allowed limit. In order to do this, you can do the following:

  1. For each session, have a field with max allowed users.
  2. Another field to have Registered users count
  3. On the session registration page where you have the button, each time a user registers for the session, add +1 to the registered users count
  4. Set visibility condition to the signup button to only show when the registered users count is <= max allowed count.

As an extra step, you can add another button to show sold out only when all the sessions slot have been booked.

I have a lot of classes (15-20 per month) so I do not want the classes to show in the list at all if they are fully booked.

From your feedback I figured out how to keep track of the number of paid registrations on the class by using the +1 formula so now on the class collection it is automatically updating the “Class Signups” column (in the attachment below). The “Class Capacity” column is just a number I enter when I create the class.

Is there now a way to only show classes in a list where the “Class Signups” are less than the “Class Capacity”?

List Filter Screenshot:

Below are the steps the user sees and selects to get to a specific list of classes:

  1. Select “Training Signup”

  2. Select the Class Type you want

  3. Select a Specific Class (this is where I only want to see classes that are not full)

Thank you!

In the above filter, did you try

Class signups is less than class capacity?

There isn’t an option for that. In the second option where it says “Empty” right now, I can only do a sum or one of the other options in the screenshot. Which I believe is summing up all of the classes capacities, not just the individual class. When I tried one of these options, no classes showed up in the list.

The list you’re trying to filter is different from Training Classes if I understand your screens right.

The fields class signups and class capacity are in “Training Classes” collection, so your filter will work on that collection.

Not sure why you’re using class type list, can you elaborate?

I am trying to filter the “Training Classes” Collection.

The user first selects which class type they are interested in, which then shows them a list of classes that are in that type.

From there I am then trying to filter the “Training Classes” to only show classes that are not full.

Yup, that’s why you’re not seeing the class signups and class registrations for filtering, because these fields are in Training Classes and not in Class Type.

Can you share your collections structure to understand this better please?

Do these screenshots help, or is there another way to see the structure?

You could technically combine the Class Types & Training Classes into 1 collection.

I would put class type as an additional field within Training Classes. That makes it easier to filter in various combinations.

Potentially improving performance too.

How would I then filter the list of classes to only show certain classes based on what type of class the user is interested in?

good question, you could use a drop down list to filter. But let me see if I can do a clone for you, thanks

Hey @djamison

Here’s how you can implement the filter and get the result you want.

  1. Each time a user register for a training class, update the count of registered users with +1
  2. Add another action immediately after the counter increment step to check if the registered users >= capacity & update the table with True/False (i.e. class is full or not-full)
  3. Now, add the filter to your list to show only classes that are not tagged as Full.


Hope this helps!

1 Like

Thank you so much! This works!

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.