I have a form submission Data Extension in Marketing Cloud that creates a Filtered Data Extension to pull in a list of leads that need to alert my sales team. The filtered data extension pulls in a group email address for the sales team using a hidden field on the form, and this is the subscriberkey in the DE. The lead's email is a text field in the data extension.
I created a journey that evaluates the filtered data extension every hour to qualify anyone NEW in the data extension, populates an alert email with the submission information, and sends that email to the group sales email address.
However, when I first turned on the DE, my settings were to allow for re-entry anytime, since each record in the filtered DE has the same email address (salesemail) and I didn't want it to dedup. This caused all form submissions to send every time the DE was evaluated. I changed the settings to NOT allow re-entry at all, and now only one record has qualified (I'm guessing this is is now a dedup issue).
Anyone had to solve for this in the past? Obviously, we are not connected to CRM using the connector, which is why I'm looking for a work around.
The goal is to get an alert email to the sales team group email address every time someone fills out a smart capture form on a cloudpage.
Thanks for any help you can provide!