Triggered Actions

[Joemac]

I'm looking to create a triggered action based on one field being updated within a table on an existing record.   So once the employee is selected from a drop down within the record I want to have an email sent to them.  The email address will need to be pulled from my employee table.  Here is what I've come up with so far - problem is an email goes out with any change made to any field within the record...I only want this to trigger when one specific field is updated to the employees name.  Help!?

example trigger.pdf

[TellMeWhy]

Use where in the select from, Where FIELD1 is not equal to Inserted.FIELD1, so you know it's changed.

[Joemac]

@TellMeWhy  does this look right?

[TellMeWhy]

20 minutes ago, Joemac said:

@TellMeWhy  does this look right?

ahh no, use WHERE instead of INNER JOIN

[Flowers4Algernon]

Hello! Just wanted to share this link for more information regarding Triggered Actions: https://howto.caspio.com/triggered-actions/triggered-actions-2/

[SunakoChan]

Hi @TellMeWhy,

You may also check other logic on the trigger: https://howto.caspio.com/triggered-actions/triggered-action-elements/logic-2/

[NiceDuck]

This should work, given that the joins are correct and the matching Data exist in all table involve.

Just make sure to use the #inserted values if you want to display the updated data.