Conditional text in SMS message

Blocks
#1

I’m creating weekly schedule notice for volunteers. Would like to list out the day(s) the volunteer is signed up in a reminder email.

E.g. "We have you on the schedule this week for;

If (Monday) print “Monday” (pseudo code)
If (Tuesday) print “Tuesday”
etc.

I have a view with this week’s volunteers names, email address, and checkbox columns for Mon, Tues, Wed, Thurs, Friday.

Questions:
Is supported in SendGrid block?
Is there an example someone could point me to for this?

I’m new. All helpful feedback welcome.

#2

Hi @Don_Hanson,

Welcome to Airtable Community! :smiley:

I would do this by having a field where you type the text message using a formula that includes the IF statements. I haven’t used the SendGrid block though, Im using Twilio and Zapier to do the same.

BR,
Mo

#3

Hi Don,

There are SO many ways to do this :). If you already have a view with volunteers names, email address, and checkbox columns for Mon, Tues, Wed, Thurs, Friday. The easiest thing I think would be to create a formula field that returns the days of the week that each person works, for instance a field named Working that has the following formula structure:

Concatenate(If({mon},“You are working Monday”,“You are NOT working Monday”), if{{tues},“You are working Tuesday”, “You are not working Tuesday”),…)

Then you add {working} into your email!

Best
Aron

Want to learn Airtable? Join me for a webinar at airtable.com/webinars

#4

Hi Aron,
Thank you much!

Don