Send SMS filter day

[Urbanlock]

What is your goal?

I would like to send an SMS only if the availability matches the current day. For example: if I put Yes in the Monday column, it means the person can receive the SMS if today is Monday.

What is the problem & what have you tried?

It works without filters, i’m a begginner so maybe it’s the wrong way to doing this. and sorry for the spelling mistakes, i’m french.

Screenshots (scenario flow, module settings, errors)

[damato]

Hi @Urbanlock

Drop the “”. Use only the values.

[Urbanlock]

Ok, thanks. but it doesn’t work. i try with a filter between my google sheets and Brevo but it doesn’t work too

[Ronak_Bhagdev]

Hi @Urbanlock, couple of fixes

1. Remove ““ from the dateFormat.

2. The time zone doesn’t translate the date. So you don’t need that param. For this you will have to translate the day names using switch()

3. Use Text operators: Equal To (Case insensitive)

   So the final condition should look like this
   {{switch(formatDate(now; "dddd"); "Monday"; "lundi"; "Tuesday"; "mardi"; "Wednesday"; "mercredi"; "Thursday"; "jeudi"; "Friday"; "vendredi"; "Saturday"; "samedi"; "Sunday"; "dimanche")}}

   

[Urbanlock]

@Ronak_Bhagdev

{{switch(formatDate(now; “dddd”); “Monday”; “lundi”; “Tuesday”; “mardi”; “Wednesday”; “mercredi”; “Thursday”; “jeudi”; “Friday”; “vendredi”; “Saturday”; “samedi”; “Sunday”; “dimanche”)}}

OMG thanks ! You’re amazing.

[Ronak_Bhagdev]

@Urbanlock I am glad it worked for you. Please mark my answer as completed/solution if you feel it worked for you.