Sync date between specific tasks in two Notion databases

How To
1

Hello everyone I would like to see if I can set up an automation to do something related to date syncs.

Context:

I work on 2 different products. Let’s call the first one “Camera” and the second one “Photo”.
“Camera” is an umbrella brand that use a database to plan their social media posts in form of tasks.
“Photo” is a sub-brand with their own social media database and their own social media tasks.

There is two databases, one for “Camera” and one for “Photo”.
I need the two databases because the team behind “Photos” is not allowed to access “Camera” social media calendar (as it’s an NDA paradise). But at the contrary, the “Camera” team needs to access “Photo” social media calendar to be able to know when they post and plan their retweet/share/reaction.

I cannot ask “Camera” to manually check “Photo” database because they are handling a shiton of posts and they easily miss a task in “Photo” calendar.

The make-around solution

At the moment, I created a button.

This button called " Copy on Camera’s calendar " function as follow:

  • When someone from the “Photo” team create a task/social media post, they click the button.
  • The button then create a task in Camera’s social media Calendar
  • Put the label “Photo” in both tasks
  • Links the two tasks together using Relation property
  • Display the linked tasks.

The issue

- The date is set to today instead of the date of publication.

I would like to be able to create an automation that sync everyday the publication date from the Photo database into the Camera database, one that triggers when it sees the “photo” label. Like that if Photo change the date of a task in their calendar, the date also changes in the camera database.

Could you help me please? I tried to be as exhaustive as possible but I’m slowly losing my marbles.

Thank you so so so much!

2

Hello,
One initial thought I have is whether you could create these two automations natively with Notion Automations. From what I understand, it seems likely that you can do this for both automations—especially for the one that creates a “replica” task. I’m less certain about the automation that updates a task.

For the UPDATE automation, if you want to utilize Make, you can use the “Search objects” module as a daily trigger and filter the results according to your requirements. Alternatively, you could use the “Watch database items” module to monitor updated database items and then add filters to check for the specific conditions you need.