Help

How to populate a date field using automations

Topic Labels: Automations
1695 1
cancel
Showing results for 
Search instead for 
Did you mean: 
alex_bray
4 - Data Explorer
4 - Data Explorer

So I’m wanting to populate a date field with a date 60 days in the future, whenever another date field is updated.
Example:
In a CRM, I enter ‘latest call date’ field as today, I want it to automatically populate "next call due’ date field with a date 60 days in the future.
Any tips?

1 Reply 1

Hi @alex_bray

Welcome back to Airtable Community!

You first need a formula field like this

DATEADD({Date Field}, 60, 'days')

If you dont want it to be a formula field for any reason, then you can use this formula field to update the other date field using an automation