AnsweredAssumed Answered

Help with a script. It needs to find matching values in a field , total and send email ... possible?

Question asked by tatucker on Nov 13, 2011
Latest reply on Nov 13, 2011 by tatucker

Title

Help with a script. It needs to find matching values in a field , total and send email ... possible?

Post

Please help!

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 topaul@tomanypauls.com
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.

Outcomes