Trigger action send email Twice

[ivan77]

Hi ,

I create a trigger action on update to send email if field value true, but why I always received double of the same email ?

I've checked the caspio email log : it is stated sent twice both to recipient and Bcc.

here is my trigger action :

Rgds

[SaraK]

Isn't it just sending one copy of the email to the TO address and one copy of the same email to the BCC address?

EDIT -- Oops, never mind. I see you are saying each of them are both getting two copies.

[CoopperBackpack]

Hello @ivan77,

This issue looks strange. Is it the only email block in this Trigger?

Could you add an additional check: to join the #inserted table with the table itself on the unique field and to check if the PAIDNO field was unchecked before the update?

In my example, the table name is 'for_submission'.

If this doesn`t help, I think it is better to contact Caspio support.

 

[NiceDuck]

How exactly are you updating your records? It is also possible that your '#inserted' contains more than one record, especially on bulk update occasions.

You can force the email block to send only 1 email by using a  'TOP 1' clause in the select block.

[ivan77]

It is solved, There is an error on my other trigger