I schedule content releases for our media vendors through our Website, We change the release date a lot according to delivery factors, like Dubbing/ Subing / Pandemic delivery circumstances.
Our Marketing team needs to see any updates happens if any changes happened in the release date, but also needs to see the old value of the release date, so they need to trigger an email once a release date has been changed, also include the old release date inside the same email.
Is there a way I can automate a copy of each older release date to the field ( Old Release Date )
let’s say my initial release date is 16/05/2021, Old release date is empty or the same as the release date
The new release date is: 18/5/2021 old release date is: 16/05/2021
again, a newer release date is 20/05/2021 old release date is: 18/05/2021, and so on.
I have a Pro Airtable account and Zapier as well, Can I automate this somehow? Thank you guys for your time, appreciate it