Validation / Report Action Timing

Dustin Bellew

• May 29, 2020 15:15

Hello,

I have a validation that checks to see if the order estimated delivery dated has been changed and then will trigger an email to the customer letting them know that their order has been delayed and provides them with new estimated dates for open line items on their order. This is all working for the most pat.

My issue comes in with the timing of this email validation trigger. The body of my email uses SQL to display the open line items to the customer along with the items new delivery date. If I use the (Before Action = True) everything triggers email is sent however the updated values do not reflect in the DB queried info in the email. If i use the (Before Action = False) the validation does not trigger and the email does not send. 

How do I get the updated info to the DB and then still trigger the email so that the customer can see updated info via the email automation?

Thanks in advance for any insight. 

 

Vote

1

• 

  Nadav Caridi

  • May 30, 2020 05:35

  Hi ,

  Not sure if this is the best approach but maybe fetch order's most recent history record and compare the date between the old and current record (?) 

   

Please sign in to leave a comment.