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...
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.
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-weekday
with 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?