What is your goal?
To get birthday reminder on telegraom, so i can send birthday wishes
What is the problem & what have you tried?
i want exact filter values and telegram values to enter
Error messages or input/output bundles
telegram gives nothing in output
Screenshots (scenario flow, module settings, errors)
birthday data.csv (12.6 KB)
Thanks Kelvin. But it is still not working. In filter, how to add?
Yeah those are not Make formulas. The guy that recommended them gave you an AI generated answer and didn’t even bother to check it.
You want to use formatDate() to change {{now}} to match the incoming format from the google sheet and then compare that.
Ok. Thanks. Can you give exact what to add?
Add a filter inside the google sheet and have it check the second column if its equal to:
{{formatDate(now; "DD MMM YYYY")}}
In google sheets, I have a single arrayfomula() in the header:
=ARRAYFORMULA(IF(ROW(A:A)=ROW(),“Birthday Trigger”,IF(B:B=“INACTIVE”,FALSE,IF(A:A=“”,YEAR(TODAY())&“-”&right(H:H,5)=TEXT(TODAY(),“YYYY-MM-DD”)))))
The birthday is formatted YYYY-MM-DD in COL H. COL B has a active/Inactive status
It’s a bit inefficient as I have learned about IFS() lol but this works for me.
After the formula is good. I simply search for a TRUE statement
I got motivated to update the formula since I looked at it… lol
=ARRAYFORMULA(IFS(
ROW(A:A)=ROW(),“Birthday Trigger”,
A:A=“”,
B:B=“INACTIVE”,FALSE,
YEAR(TODAY())&“-”&right(H:H,5)=TEXT(TODAY(),“YYYY-MM-DD”),TRUE,
TRUE,FALSE
))
The naming of the header will only work if it’s on Row 1. if your headers on row 4 for example, it’d have to look like:
=ARRAYFORMULA(IFS(
ROW(A4:A)=ROW(),“Birthday Trigger”,
A4:A=“”,
B4:B=“INACTIVE”,FALSE,
YEAR(TODAY())&“-”&right(H4:H,5)=TEXT(TODAY(),“YYYY-MM-DD”),TRUE,
TRUE,FALSE
))
