Linking due dates in multiple tabs

[Jenny_Hislop]

Hi, I’m looking for a way to streamline entering the same data in Airtable in a few different places. I enter due dates for an entire project, but we have SMEs that enter some of the same due dates in another tab for when each individual channel will Go-live. Is there a way to link individual task due dates to another tab’s individual tasks?

[Hannah_Wiginton]

Hey Jenny,

Here are a couple of ways you can do this.

1. Create an Automation that copies the date from one field to the other
2. Create a Due Dates table with the Primary field being a date field. Then link that everywhere.

[Jenny_Hislop]

Thanks! Do you have a link to an article on how I would do either of those?

[Hannah_Wiginton]

Here are a few starting places

look at the ‘When Record is updated’ trigger

Airtable Support

When record is updated trigger

Overview When building an Automation, you may choose a trigger that will start the automation. The "When record updated" trigger allows you to select an entire record, or individual fields in a rec...

[Hannah_Wiginton]

Sorry I clicked enter too fast!

and look at the ‘Update a record’ action

Airtable Support

Update record Action

When building an Automation, you may choose the "Update record" action to update a single record. When the automation runs successfully, one record will be updated in a specified table. The "Update...

[Hannah_Wiginton]

and the Primary Field - You can link this to multiple tables as a linked record

Airtable Support

The primary field

The primary field is akin to the concept of a primary key in relational databases. In Airtable, the primary field is most often a text type field. However, it can also support many other field type...