How do I configure an Airtable field to track the previous value of another field?

Hi @edmae 

Good question.

Why not set both Field values when you originally input the data?

Otherwise, try using Airtable Automations to set this value: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overview

Hi @Troy Tessalone ,

Thanks for the quick response.

Yes we have tried to do it by automations in Airtable, but it’s just copying the changed date.

I need the old date to be retained so other collaborators can see the changes. I know they can just look it up through the record history, but they want it to see for comparison purposes, like presentations and stuffs.

Is there any way through Zapier to do it?

Thanks!

@edmae

When you first enter the Shooting Start, then have an Airtable Automation that sets the Old Shooting Start, by using this trigger logic:

When record matches these conditions:

Shooting Start is not empty

AND

Old Shooting Start is empty

Once both field values are set the Airtable Automation won’t run again.

Hi @edmae! I wanted to drop by and see if Troy’s suggestions helped get this sorted for ya? Keep us posted! 🤗

hi @christina.d 

thanks for checking in, unfortunately no.

My manager actually found a way to dig deeper into it, he integrated on2air to zapier and to airtable.

I think it’s not possible just by doing automations as he did it by scripting.

Anyways, thanks for the responses!

Thanks for keeping us in the loop on what worked for ya’ll, @edmae! If he’s open to sharing any details, we’d love to hear it. 😊