Auto Action email sent multiple times

I wasn't able to find this in the current support forum so if it's been answered, I apologize up front.

I have an auto action that is triggering on the "After Commit Field Data Save" trigger and performs an email type of action. The idea is that when we set a CB checkbox attribute, I want to send a welcome email to that member notifying them of certain benefits they have access to. The email goes out, but goes out multiple times. 35 to be exact. The condition is checking the CB field for a value of 1 to perform the action.

I also have a similar action to set the access level (UG) to a specific value as well on the same condition in a different auto action. Not sure if this is getting done multiple times there as well but it seems to work.

Any thoughts on why I'm getting multiple emails?

That trigger fires for every field when its value is being committed for save. So if you've 35 fields it will fire 35 times. Use the after profile update trigger instead.

Awesome, thanks. That got rid of the multiple emails on each check of the checkbox.

Now I'm getting an email any time I make a profile change (After Backend Profile Update). Is there any way to see what the conditional value is before and after like in a SQL trigger? In this case I'd want to check the condition of:

if previous_value = 0 AND new_value = 1 then send the email

Thanks.

The below conditions should work.

Conditional 1: [var1_cb_field] Not Equal To [var3_cb_field]
Conditional 2: [cb_field] Equal To 1

The first condition checks that the field changed (var1 is the new user object where var3 is the old). The second condition checks that the checkbox field has been checked. The below would probably also work.

Conditional 1: [var3_cb_field] Not Equal To 1
Conditional 2: [var1_cb_field] Equal To 1