Skip to main content
  • EN

I am using FME Form 2021. 

I have a table with vehicles listed by department. 

 

Vehicle 1234 Department 1

Vehicle 4532 Department 1

Vehicle 5645 Department 2

Vehicle 8472 Department 3

 

When a new record (example: a vehicle) is added to the table, I want an email to be sent only if the new vehicle is associated with a specific department. For example, Vehicle 6577 is added to the table and is associated with Department 3; thus, an email would be sent notifying the recipient that a new vehicle has been added. However, if the vehicle is associated with Department 1, then no email would be sent. 

 

What Transformer(s) that would trigger the email do you recommend I use to achieve this? It sounds like ChangeDetector could be an option, but I am only using a single table.

You need to know what rows have been added since oyu last checked the data. Theres a few approaches to this

  1. Have a field in the table that says when the record was inserted. Then you can check what has been added since you last ran FME using the date/time stamp.
  2. Each time you run the process you store a local copy of the table. The next time the process runs you check your local copy against the ‘live’ copy. This will identify rows that have been added. At the end of the process, you update your local copy so it mirrors the live copy

Reply


Community Stats

30,351
Posts
115,336
Replies
38,078
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.