Great video! I'm trying to add an entry to a Notion database for each calendar event in my MS365 calendar, but can only figure out how to get it to add a new record each time a new calendar event it created. Same process for google calendar to google sheets I imagine, if that is a more common use-case. Can I trigger something like: every morning or every hour, create a record for every event on the calendar that doesn't already exist in the Notion table so that it picks up the loads of events that are already on my calendar and recurring events?
I have learned a lot! I want to calculate the latest date based on a condition. I have tried the function MAX but it only works with numbers not dates. Which function would you use?
@@miguelangelfernandez4099 you could convert the purchase date to a unix timestamp, and the current date to a unix timestamp. Then, subtract the purchase unix by the current date unix. That will give you the amount of seconds since their purchase. You can then divide that by 86400 to get the amount of days since purchase. Hope that helps! Alternatively, you could also schedule the email 30 days into the future whenever they purchase something. Maybe that's easier to manage.
Hi !! Thanks for the video. I am trying this tutorial in order to get a reminder from a meeting (in Google Cal). I am using the Watch events by Starting Date, adding a day, but I still get the reminder from the day of the meeting and not the day before. Can you help me?
Hey Max Great video, helped a lot. Is there a way to specify in code that I want to run it in certain timeframes? for example business days from 9-5 run business days from 5-9 run something else weekends run last script
Heyhey! If there's a scheduled start trigger, you can set it to run the scenario only during those times. You'll find it under the 'advanced' settings of the schedule setting.
Hey John! I'm not sure if this is the best solution, but this is what I have been using: 1. You format the birthday to a Unix Timestamp. 2. Format the current date & time to a Unix Timestamp. 3. Subtract the unix timestamp of the birthday from unix timestamp of the current date & time. This will give you the amount of seconds since the birthday. 4. Divide that amount by 31536000, which gives you the amount of years. 5. Use the floor() function to round it down. Hope that helps! Email me if you would like a screenshot of the formula 🙂
On the 10th of each month I send a report for the previous month...so I need to have the name of the previous month in the title of the email. What will be the correct formula in this case?
Hey Ron! I think the easiest way is to format the date you want to check to MM/DD/YYYY and then also format the now variable to MM/DD/YYYY. Then, you can easily compare if it's equal to today's date.
Not that I know of, at least not out of the box. But I've used the replace() function in the past to replace the English names by Dutch names. Or you could try to use the Google Translate module. Hope that helps!
You'll first have to use the formatDate() function to get the current day of the week in English: formatDate(now; "dddd") And then you use the replace function to replace all the days of the week by your language: {{replace(replace(replace(replace(replace(replace(replace(formatDate(now; "dddd"); "Monday"; "maandag"); "Tuesday"; "dinsdag"); "Wednesday"; "woensdag"); "Thursday"; "donderdag"); "Friday"; "vrijdag"); "Saturday"; "zaterdag"); "Sunday"; "zondag")}} It's a bit of a long formula, but it works. And you can then use it it whatever module you want (in an email module for example) 🙃 Hope that helps!
How can i get the last date of next month? suppose, Today is 6/8/2021 now I need the last date of this month, like: 6/30/2021. what if the month is February/ March/May? how can I get the last date of a month?
Hey Shraban! I think the easiest way is to first use the setDate() function to get the first day of this month, and then use the addDays() function to subtract one day. That will give you the last day of last month. The formula looks like this, you can copy and paste it into Integromat if you like: {{addDays(setDate(now; 1); -1)}} If you want to format it to MM/DD/YYYY, then you can use the formatDate() function: {{formatDate(addDays(setDate(now; 1); -1); "MM/DD/YYYY")}} Hope that helps! 🙌
Ah, sorry. I see that I read your question wrong. You want to get the last day of this month, not of last month. That works very similar: 1) Use the addMonths function to add one month. 2) Use the setDate function to get the date of the first day of the month. 3) Subtract one day to get the last date of this month. Formula looks like this: {{addDays(setDate(addMonths(now; 1); 1); -1)}}
@@maxvcollenburg Just my anger got in the way........... 3 days in and 2 aneurysms later.... I figured it out..Thank you for your reply and videos... I am a fan
![Integromat Text Functions [2022 Tutorial]](http://i.ytimg.com/vi/xKSd-LRLhFE/mqdefault.jpg)
![Integromat Text Functions [2022 Tutorial]](/img/tr.png)
Thank you very much!! I am a Brazilian and this video literally save me
This is a video that is very helpful! It still works in "Make".
Muchas gracias bro! Me ayudó!
Thanks Max!
You're welcome!
saved me! Thx bro, i was stuck
Glad to hear that!
Thanks for your help... it was even better than gpt's answer 😜
Hi Max, is it possible to set up a filter using start and end times in the current day?
Great tutorial.
Thanks! Glad you like it!
How to apply filter for boolean?
Hi! I would like to send an email the day before of a cell value (date) on a google sheet. I'm not being able to. what do yuo suggest?
Great video! I'm trying to add an entry to a Notion database for each calendar event in my MS365 calendar, but can only figure out how to get it to add a new record each time a new calendar event it created. Same process for google calendar to google sheets I imagine, if that is a more common use-case. Can I trigger something like: every morning or every hour, create a record for every event on the calendar that doesn't already exist in the Notion table so that it picks up the loads of events that are already on my calendar and recurring events?
I have learned a lot! I want to calculate the latest date based on a condition. I have tried the function MAX but it only works with numbers not dates. Which function would you use?
Hey Miguel! What do you want to calculate with the latest date exactly? How many days/hours have passed?
@@maxvcollenburg I want to send a courtesy email to any client whose last purchase is older than 1 month (30 days). Thanks beforehand!
@@miguelangelfernandez4099 you could convert the purchase date to a unix timestamp, and the current date to a unix timestamp. Then, subtract the purchase unix by the current date unix.
That will give you the amount of seconds since their purchase. You can then divide that by 86400 to get the amount of days since purchase.
Hope that helps!
Alternatively, you could also schedule the email 30 days into the future whenever they purchase something. Maybe that's easier to manage.
@@maxvcollenburg Thank you very much! I wouldn't ever come to that solution.
Hi !! Thanks for the video.
I am trying this tutorial in order to get a reminder from a meeting (in Google Cal). I am using the Watch events by Starting Date, adding a day, but I still get the reminder from the day of the meeting and not the day before. Can you help me?
Hey Max, How can we add time (current time) to date. if date is only specified as a parameter.
Hey Max
Great video, helped a lot.
Is there a way to specify in code that I want to run it in certain timeframes?
for example business days from 9-5 run
business days from 5-9 run something else
weekends run last script
Heyhey! If there's a scheduled start trigger, you can set it to run the scenario only during those times. You'll find it under the 'advanced' settings of the schedule setting.
Max! When will be your personal Integromat Mastery Course?
Haha, I'm actually working on one.
I hope to have it ready in 3-4 weeks.
@@maxvcollenburg Thank You! We are waiting.
Thank you Max - How would you calculate the age of someones birthdate?
Hey John! I'm not sure if this is the best solution, but this is what I have been using:
1. You format the birthday to a Unix Timestamp.
2. Format the current date & time to a Unix Timestamp.
3. Subtract the unix timestamp of the birthday from unix timestamp of the current date & time. This will give you the amount of seconds since the birthday.
4. Divide that amount by 31536000, which gives you the amount of years.
5. Use the floor() function to round it down.
Hope that helps! Email me if you would like a screenshot of the formula 🙂
@@maxvcollenburg could you send me a screenshot of the formula? Thanks
On the 10th of each month I send a report for the previous month...so I need to have the name of the previous month in the title of the email. What will be the correct formula in this case?
This formula will give you the month name of last month 🙃
{{formatDate(addMonths("now"; -1); "MMMM")}}
Hope that helps!
How do you set filter if the record is equal to today?
Hey Ron! I think the easiest way is to format the date you want to check to MM/DD/YYYY and then also format the now variable to MM/DD/YYYY.
Then, you can easily compare if it's equal to today's date.
Is there a metod to put the name of the day (dddd) in other language?
Not that I know of, at least not out of the box.
But I've used the replace() function in the past to replace the English names by Dutch names.
Or you could try to use the Google Translate module.
Hope that helps!
@@maxvcollenburg Useful! Thanks
@@maxvcollenburg Can you tell me how and in what module you use replace() function?
You'll first have to use the formatDate() function to get the current day of the week in English:
formatDate(now; "dddd")
And then you use the replace function to replace all the days of the week by your language:
{{replace(replace(replace(replace(replace(replace(replace(formatDate(now; "dddd"); "Monday"; "maandag"); "Tuesday"; "dinsdag"); "Wednesday"; "woensdag"); "Thursday"; "donderdag"); "Friday"; "vrijdag"); "Saturday"; "zaterdag"); "Sunday"; "zondag")}}
It's a bit of a long formula, but it works.
And you can then use it it whatever module you want (in an email module for example) 🙃
Hope that helps!
@@maxvcollenburg Fantastic, very nice.
How can i get the last date of next month? suppose, Today is 6/8/2021 now I need the last date of this month, like: 6/30/2021. what if the month is February/ March/May? how can I get the last date of a month?
Hey Shraban!
I think the easiest way is to first use the setDate() function to get the first day of this month, and then use the addDays() function to subtract one day.
That will give you the last day of last month.
The formula looks like this, you can copy and paste it into Integromat if you like:
{{addDays(setDate(now; 1); -1)}}
If you want to format it to MM/DD/YYYY, then you can use the formatDate() function:
{{formatDate(addDays(setDate(now; 1); -1); "MM/DD/YYYY")}}
Hope that helps! 🙌
Ah, sorry. I see that I read your question wrong. You want to get the last day of this month, not of last month.
That works very similar:
1) Use the addMonths function to add one month.
2) Use the setDate function to get the date of the first day of the month.
3) Subtract one day to get the last date of this month.
Formula looks like this:
{{addDays(setDate(addMonths(now; 1); 1); -1)}}
Do more ActiveCampaign videos u.u
Any ActiveCampaign tutorials in particular you would like to see? 🙃
Any idea...WTH this is............ 12 hours of learning has yielded NOTHING..... Update Airtable Record.....ERROR = Invalid date in parameter
Hey Jeremy! I haven't used Airtables, but maybe you're entering the date in the wrong format?
@@maxvcollenburg Just my anger got in the way........... 3 days in and 2 aneurysms later.... I figured it out..Thank you for your reply and videos... I am a fan