Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Need a Script that finds matching values, total how many matching ...


tatuck
 Share

Recommended Posts

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 to paul@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.

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use