Notion : Change status depending on Date property

Questions
1

Hello Makers, in a database, I have 4 status :

  1. Sent
  2. Confirmed
  3. Done
  4. Paid

Once a mission is Confirmed, status change depending on date’s mission, which is a property in database.

So I would like to automate status change from Confirmed to Done once it’s the day of the mission, any idea to do that?

Best,

2

You can use the Notion “Search Objects” module

Screenshot_2024-03-22_230345

  • Find items that are on the current date or earlier AND have a status that is NOT “Done”

Then, use the “Update a Database Item” module

Screenshot_2024-03-22_230311

  • Update the item status to “Done”
3

Hello, Thank you @samliew. I created the scenario, I’ll let you know if it works :+1: