Create a Database Item input is different than SearchObject output

[iacosite]

To get helpful responses

I am trying to implement recurring tasks in a notion database. I am thinking of implementing them by:

• Have a parent task that specifies how often a task is repeated (field Recurrence)
• Have make.com create tasks in the database (with Recurrence set to 0)
• Run the make.com script daily:
  • Read all the tasks with Recurrence > 0
  • Create the new tasks (name: parent’s name + today’s date, Recurrence set to 0)

What I tried:

This is my database:

This is what I think the workflow should be

This would be my goal output:

Instead, I receive this:

Current implementation

The SearchObject connection correctly reads the data:

However, it looks like the Create a Database Item object receives something different:

And this is how I set up the Create a Database Item object.

My question

What am I doing wrong?

[Albert_Medov]

Hello there!

I will try to help you out🙂

Before we start, I’m wondering, have you already tried to use a recurring task in Notion itself? Is this not suitable for your purposes?

Here’s a screentshots where you can find it just in case🙂

[Albert_Medov]

So, anyway, here is the solution:
You need to use “now” instead of “timestamp” in the Create Database Item module.
I’ve built a setup exactly as you described, and it seems to me that your goal is achieved.
Here are some screenshots:

[ThakurHemansh]

Hey @iacosite Here is a troubleshoot solution for you:

The first step is searching for the tasks that have a recurrence greater than zero. Your configuration seems correct as long as your filter is set to find the objects with "Recurrence (days)" > 0. Ensure this filter is accurately capturing all the tasks that should recur.

For each task captured by the filter, you’re looking to create a new task with a name that is a combination of the original task’s name and the current date, while setting the new task’s recurrence to zero. In your Create a Database Item setup, you’ll need to ensure the name is correctly concatenated with today’s date and that the correct formatting is applied.

The screenshot where the task’s name is 20-01-1970 12:18 suggests there might be an issue with the date formatting or the date value provided to the creation module.

[vendy]

Hey there @iacosite

just wanted to ask whether you had some time to check out @Albert_Medov’s and @ThakurHemansh’s suggestions to fix your troubles. If you did could you let us know if any of them did the magic and solved your troubles?

Thanks a lot!

[iacosite]

Hi! Thank you for the help!
I didn’t know about the repeated tasks feature, thank you for pointing it out to me @ThakurHemansh ! I am trying it out and it looks like it does what I tried to implement here!

Going to the make.com worklflow,
I fixed the timestamp vs now issue, and now it works!

I think the issue was either that or that I was trying to run each single module by right-clicking Run this module once instead of the general workspace Run once.