Backend Workflows - sending email when quotation id repeats

[domreg]

Hi,
I need help here please.
I have a table called invoice. In this table I have a field called Quotation ID.
I want to send an email notification to me if this table has duplicate Quotation IDs.

I started a backend workflow and I am stuck here.

I have these data in my Invoice table.

The email still gets sent to me even though there are no duplicate quotation IDs

I need the email to be sent to me when the quotation id repeats.

Any help is appreciated.
Thank you so much

Alvin

[tylerboodman]

Your trigger needs a condition on it, right now any change on any invoice is triggering it.

Something like When Invoice Before change is empty so it only runs when a new one is created.

The condition on the action needs to beSearch for Invoices:count > 2 (constraint Quotation ID = Invoice now's Quotation ID"