I am currently working on a project where I aim to set up automated birthday triggers using Google Calendar. Specifically, I want to create a scenario where the Google Calendar event for a user’s birthday triggers on their birthday and sends notifications via email or SMS.
I have successfully created the scenario and tested it with dates like 19/11/2023 and 20/11/2023, and successfully received notifications via email and SMS as preconfigured. However, I am facing an issue. I want the calendar event to trigger only for users whose day and month match the current day and month.
For instance, I tried setting a user’s date to 21/11/2001 to see if the event would trigger on the day (21) and month (11), but it didn’t. Instead, the calendar triggered other events, such as April 24, 1980.
I would appreciate any insights or suggestions on how to ensure the calendar event triggers accurately based on the current day and month.
To be sure that I well understand, you want to extract from your calendar all the events having a date like DD-MM without considering the year, that’s it?
In the query field, you could define a predicate like:
data_name = formatDate(now; “DD.MM.YYYY”)
where data_name is the name of the variable corresponding the the date in Calendar.
If start is the date of interest, yes.
After in the Query field, you have to “play” with the time functions.
You could try this:
formatDate(start; “DD.MM”) = formatDate(now; “DD.MM”)
Not sure that it works directly, you can also share your intermediate results.
Sorry, you have to use: {{formatDate(start; “DD.MM”) = formatDate(now; “DD.MM”)}}
or you can retype the “code” using the buttons in the contextual menu.
There is something strange (but it will not solve the problem), when you paste the “code” I gave you, you should have obtained: (the " " are not useful)
As you can also see, there is a comment saying that it searches for events containing the specified text.
Here, I led you down the wrong path thinking that querying was like every other database, but it is not.
