1 Reply Latest reply on Nov 13, 2011 1:06 PM by tatucker

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

    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.