Skip to main content

How would you link 2 tables - calendar of events and tasks

  • August 7, 2023
  • 1 reply
  • 22 views
L
Forum|alt.badge.img+6

Hi everyone, 

I've got two tables in two different bases.

  • calendar of articles
  • tasks

I'd like to create a task for each calendar item and only need to update one table. 

Just looking for ideas on the best way to link these bases. 

My current idea:

  • is to sync the calendar table into the base with the tasks
  • link each calendar task to the calendar item. 
  • Use an automation to update the task status

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, could you tell me more about your current idea and why you'd need an automation?

If you're updating the task statuses within the "Tasks" table, you could use lookups / rollups to pull the task statuses over to the events table to view them if needed? 

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement