Automation to catch a discontinuity from a form submission

[v1_oh_n0]

Hello,

As the title implies I am looking for an automation to catch records created by a form and notify via email when there is a discontinuity from the last submission. For example if the miles entered on a particular vehicle in the last submission were 101 but the next submission starts at 101.3, an email is sent to notify of the discontinuity.

Thanks!

[TheTimeSavingCo]

Does each form submission contain a piece of unique data that you can use to tie to the previous form submission?  With your example of vehicle miles perhaps you'd be tracking the VIN number and so you could use that?

If so, I would try:
1. Create a new table where each record represents a single VIN and link it to the form submission table
2. Create an automation that will trigger when the form is submitted and link that form submission to the appropriate VIN 3
3. In the form submission table, create an Autonumber field
4. Use rollups and lookups to identify the latest and second latest form submission per VIN
5. Use those lookups in formulas to get the difference between the latest and second latest miles submission

You can then use that formula field to power your automation

Link to base