I have a Form named as add_class
1. school_name (lookup field) from Form school_master
2. program_name (single line field)
3. max_student (number field)
4. start_date (date field)
5. end_date (date field)
And in my website there is Form named as Registration. Which have many different fields including
school_name, program_name, start_date and end_date .
what i need is when the max_student value exceeded for that particular program_name in that school_name then nobody can submit more entry in Registration Form in website , instead if anybody fill and submit Registration Form then it shows alert or popup to them that class is full can not add more.
And also if the start_date is zoho.currentDate then no one able to fill the Registration Form , shows alert or popup again as same.
Note:- In one particular school_name there will be many program_name And for every program_name the value of max_student is different .
How can i achieve this ?
Thanks in advance for your help !!