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.
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:
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:
Select “Training Signup”
Select the Class Type you want
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?
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.
Hope this helps!
Thank you so much! This works!
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
