Email records

I need some help please.

I have an form that makes a payment, when this payment is made, the sum is taken off of another value (the purchase order value) this updates a field “Purchase Order Value remaining”

I wasn’t to set up a custom email that is sent when the Purchase Order Value Remaining" field goes below a certain level. However, I cannot see how to do it. I can’t add it to the form, even if I set up a connection with it in the other table.

Any help appreciated.

Thanks!

I have worked it out, just put an equation value in the form :+1:

1 Like