Skip to main content

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.

Hi @Don_Hanson,


Welcome to Airtable Community! :grinning_face_with_big_eyes:


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

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

Hi Aron,

Thank you much!


Don

Reply


Terms & Conditions