I’m managing a conference registration process, and have a table of registrants gathered by a form which includes a formula field with names something like 02_SAT_COUNT that shows a 1 or 0 depending on whether the registrant selected a particular session in their registration form. This was created using a formula to see if a particular option was selected in a multiselect field, so it is not using linked records. What I need now is a way to send me an alert when the total number of registrations for a particular session reaches the maximum, so that I can remove that option from the registration form, thereby closing that workshop to further registrations. I have a separate table that lists all the sessions being offered, each using a unique code 02_SAT or 03_FRI that is similar to the one used in the name of my registration formula fields such as 02_SAT_COUNT.
What I’d love to do is find a way to increment a field in the Sessions table each time a new registration shows a 1 in the correct registration formula field, so that I have a running count of registrations for each session that can be used in automations, but I’m open to suggestions.