How to add a time delay in days

How To
1

Hello,

I’m new here so nice to meet you all. I have hands-on experience with Pabbly, and I am nearing the completion of Make’s online courses.

I try to add a time delay in days. I know that I can use the sleep function, but it is possible to delay the scenarios by up to 5 minutes. So I had to find another solution. So I created Json, HTTP request and sent the data to another scenario. There, I schedulled the scenario activation to the time I wanted.

However, when I have to do that every day separately, it becomes a tricky task. Meaning that, I’ll have to create six different routes. Then send the data to six scenarios.

So my question is, is there a way to add days’ delay which will be easier?

Thank you

2

Hi,

Even if you find a module of delay with 5 days, Make scenarios can’t last more than 45 mins total AFAIK.

HTTP request was the method I thought first too, but it’d be probably better to store the data in a Google Sheet or other database with its’ execution time (current time) and time of second scenario to be executed (+5 days).

In the second scenario (executed every day), we’ll check if the date written in the database is equal to today’s date, and if it is, continue with the script.

3

Hey @ori_dror

This post could you help you.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

4

Thank you!

Just to make sure. I should start a new scenario. Then in the first model I will have to use the search Google Sheets model. In the filter I’ll have to choose the column with the delayed dates. Then, change the filter to time operators equal to and add the function now below (equal to now). Am I correct?

5

@ori_dror, I’d use 1 row of sheet for this. Put your data in A2:Z2 and you’ll update this data whenever first scenario is ran.

For the time comparison, use Google Sheet : Get Range module and in the filter :

formatDate(sheetdata;DD/MM/YYYY)
time operator : is equal to
formatDate(now;DD/MM/YYYY)

This will ignore the time difference in hours/mins/seconds and focus on the day.

6

I’m sorry but it doesn’t work.

I did what you asked me for. But in the filter, I get an error that the values aren’t dates. So, the filter isn’t working. What do you mean by using sheetdata? Could you kindly share with me a screenshot?

7

@ori_dror Hi,

Here’s an image of Sheet data :

image
image498×216 12.9 KB

Google sheet link (please make your copy and modify sheet ID in Make) :
Sheet link

And here’s the Scenario Make (with filter) :

image
image1200×900 99.1 KB

Make scenario blueprint attached :
blueprint.json (6.7 KB)

8

Thank you.

It is a bit different from what you had suggested. I needed to use the search Google Sheet model. After testing it, it worked.

Actually I found a Make’s video explaining how to do that: https://www.youtube.com/watch?v=3Ec1Zx_11VM

9

Thanks for the video. I’ve never used Data store module before - it can be much easier without using whole Sheet for that one value :slight_smile: .

10

Welcome to the Make community!

You can have a scenario watch new items and schedule a cron job callback using apps like 0CodeKit that allows you to schedule a “callback” to a URL defined in a “Custom Webhook” trigger in another scenario at the exact time you want

389×181 8.51 KB

You don’t have to use a data store, this is just an example. You can use Google Sheets, Google Calendar, etc.

Alternatively, if you are already using Airtable, you can use an Airtable formula and built-in automation, briefly mentioned here.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

11

Yes, it should be easy:)

12

Actually I used Google sheets which worked great. Thank you!

I didn’t know about the 0codekit which is more similar to automations that I know and have used before. Thank you for presenting this option.