I could not find a sollution to the following Problem:
I have a table for which I provide a web form, where users can make entries, if they want to participate on certein courses.
The number of participants per course is limited.
Now, I want to automatically prevent registrations for courses that are already full.
Ideally, the webform would disable the selection of a course if the max number of registrations is met.
Thank you for your reply. Unfortunately, that would be a horrible sollution, as a participant, who fills in the form, rightfully expects his place to be set. Such thing would require the admin responsible for training spaces to manually contact each and every person, who signed up after the limit was reached and apologize etc.
I fear inthis case, Excel will continue to do the trick…
Thank you. That might work. Yet, I have solved it otherwise:
I created a table for each and every training and for each one a registration form, in which I check a counter column, if a max counter is hit. Then I send an email to the applicant, telling him his registration could not be met, due to the course being full.
Although this works, there are would have been a much nicer way:
Have the different trainings being defined in an own table
Have the registrations in another table and link each registration to its training and cutomer
have an automation rule check, if the max counter of a training is hit
But: I found no formula or whatever to count entries based on a expression. For example: one cannot count the registrations for the training “How to recognize SPAM Mails”.
In contrast, if I group the registration table view by the kind of training booked, I get that sum easily shown in the grouped view.
Why is there no function to count by expression, or did I just miss it and it is there, somewhere?