Showing revision change in an automated email

[Kiersten_Kollin]

Hello,

We are on the enterprise version and we are wondering if it is possible to pull in a revision into an automated email.

For example, we want to be able to show a change in dates and would like to be able to show the old vs. new date within an email.

Not all of our users are in Airtable and we would love to be able to be transparent with our teams on what something was to what it is now for a change in dates.

Thanks!

[bruceconsulting · Accepted solution]

Hi Kiersten,

I have done this before by adding 2 new date fields and an automation.  

1.  Add 2 new date fields named "new date" and "prior date".  I'll call your current date field "date".
2.  When the "new date" field within a record is updated, the automation copies your "date" field to the "prior date" field and also copies the "new date" field to your "date" field.
3.  The automation email can now use these 2 fields.

If you want to talk about this further or if you ever need additional help, please schedule some time with me.  Here's my Calendly link: https://calendly.com/d/zyc-nx6-m54/30-minute-help-meeting

Jody

[Kiersten_Kollin]

Thank you Jody! This worked perfectly!