Records Updated at Same Time with Same Information - Send Trigger Separately
I apologize if this is similar to previous questions - but running into an occasional problem:
I have a script setup to basically send a "Welcome" email if someone becomes a Member - this looks at their Membership Date, Member Status, etc.
One thing that happens occasionally is that it's possible for multiple Members to be approved on the same day with the same Email Address (a major flaw with our system data-wise).
This means that if I've got multiple records in the Lead with the same:
01) Membership Opening Date
02) Membership Status
then my "#foreach" loop will obviously pull in each record that meets those criteria. That means using a "Updated Customer Profile Object" will send multiple emails to the same address with the multiple records data.
Is there any efficient way to basically say "if multiple records meet the criteria, only print ONE RECORD per email when triggered"? Or am I better off trying to have our data team delay the records updating and do something with the "UpdatedAt" field?
