How to build a scheduler in Integromat?
Hi, and welcome aboard @laceykesler.
How do I create an assignment scheduler in Integromat?
When a new record comes in from Monday.com, I want to set some upcoming time in Google Calendar to work on that assignment.
That time should be...
- The next weekday ("tomorrow" is not sufficient as, on Friday or Saturday, that's a weekend day).
- On that day, Check a Google Calendar for time, starting from 9am, in 45-minute increments, beginning 9am-9.45am.
- So, if 9am-9.45am is free, create an event at that time. If not, if 9.45am-10.15am is free, create one then. And so on, 10.15am-11am, 11am-11.45am.
My current "Set writing date" step simply gets "tomorrow", without identifying the next weekday:
({{formatDate(addDays(now; 1); "MM-DD-YYYY")}})
And I don't know know how to handle the time checking and setting.
Thanks.
Trending on Indie Hackers
Hey @RobertAndrews
I made a Micro API to solve this problem. You can use it via the HTTP module.
Make a POST request to
http://dates.micro-apis.com/next-weekdaywith a JSON body of{ "date": "2020-09-26", // Use the now helper in Integromat "format": "yyyy-MM-dd" }You'll get back:
{ "date": "2020-09-28" }@ccummings your micro-API is beautiful for finding next-weekday - thanks!
I'm going to want to try implementing two enhancements to the scenario:
i) Only schedule for next weekday if the assignment comes in 3pm-11.59pm the day before an available weekday. ii) Else, if it comes in during a weekday morning, schedule for that morning.
Figure out how to schedule in non-overlapping, available GCal time, 45-minute increments starting 9am.
Thanks again!
Hey @RobertAndrews
Tbh, I'm not sure. I'm more of a Zapier user. Have you reached out to their support directly?