Backend Workflows - sending email when quotation id repeats

Need help
1

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.

image
image750×822 33.2 KB

I have these data in my Invoice table.
image

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

image
image1078×344 21.9 KB

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

Any help is appreciated.
Thank you so much :slight_smile:

Alvin

2

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"

3

This topic was automatically closed after 70 days. New replies are no longer allowed.