Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

899 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lindsay_Patross
6 - Interface Innovator
6 - Interface Innovator

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 1

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?