Help

Automation to catch a discontinuity from a form submission

Topic Labels: Automations Formulas
263 1
cancel
Showing results for 
Search instead for 
Did you mean: 
v1_oh_n0
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1

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


Screenshot 2024-05-03 at 11.05.24 AM.png

Screenshot 2024-05-03 at 11.05.46 AM.png

Link to base