Backend Workflows - sending email when quotation id repeats

domreg · 2024-09-20T02:34:32.248Z

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.

image750×822 33.2 KB

I have these data in my Invoice table.

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

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

Alvin

tylerboodman · 2024-09-20T05:00:52.001Z

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"

system · 2024-11-29T02:34:53.533Z

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