Help with a script. It needs to find matching values in a field , total and send email ... possible?
Need a Script that finds matching values, total how many matching, then if that number is greater than or equal to 3 it sends a notification email to someone. If it is less than 3 it ends.
This will be a scheduled server side script.
Here is an example:
the server side script runs,
it gets the table labeled "people" field "first_name"
it sorts and finds all of the people with the first name "paul"
it counts the number of people named "paul" and finds that there are 4
because 4>3 it sends an email notification firstname.lastname@example.org
the email says "there are more than 3 paul's are in your database"
Any help would be great. I just need the system to notify me if a field has the exact same information in it once it reaches a specific level, in the example above, 3 pauls.