Validate unique before inserting record
Is it possible to add a validation to an insert single record behavior for the following scenario:
table structure - record_Id | user_id | date (Y-m-d)
The insert record behavior is on a WADAusers login page. When the user successfully logs in, it records an auto increment record_Id, the user_Id, and the current date in Y-m-d format. I would like to prevent a user from logging in more than once per day. But there will be multiple users logging in each day, so I can't make the date column unique.
Thank you