This topic is locked

Count added records and send personalized mail

5/17/2022 6:35:37 AM
PHPRunner General questions
A
alfonso authorDevClub member

I am designing a registration form for an activity. When interested people sign up, they receive an email with the details and more information. Since the enrollment limit is 20, for example, I want the person who enrolls and occupies the 21st place to receive a different email indicating that he is a student who is in the reserve. Any idea how to do it?
thank you

Another question is how I can activate the form on a certain day and time and automatically deactivate it another day

admin 5/17/2022

Sounds like a job for BeforeAdd event. In this event you can check the number of records and do something like display a message or send an email to the user:

select count(*) from tablename