Explore

Auto Remind Me ?

Coda is perfect to manage your tasks and also your meetings. With this little trick, here is how you can send to yourself mail with tomorrow’s tasks (or any schedule you may want), so that you won’t forget anything, even if you don’t log to coda !

I personnaly use it to remind my 😷 medical appointment !

This article show you how to use
the gmail pack⁠
for your reminder sending !

⁠

For the purpose of this article, let’s assume that today is

9/29/2022

⁠

. But for you use, you will work with Today() function, of course ! It just allow the article to remain relevant even if the due dates of the tasks won’t fit the good “tomorrow” date 😉

✅ First Step : Check your Tomorrow’s tasks or meetings

Let’s consider a list of tasks, with a given due date. We would like to know if the due date is tomorrow, in our case it will be :
9/30/2022
⁠
, linked to the control above. So it’s a classical comparison in a new column:

If(thisRow.[Due Date]=Today()+1,1,0 )

RemindedTask

RemindedTask

Task

Due Date

DD_Tomorrow

Call Mister B.

9/29/2022

Eat Fajitas

9/30/2022

Important Meeting

9/30/2022

Build a new dam

9/30/2022

Throw my phone

9/16/2022

Clean my data

9/30/2022

Secret Stuff

9/30/2022

There are no rows in this table

⁠

Really easy ! And you can of course change the parameters, according to your needs !

For example, we may want to have all the tasks of the week after this one, using then this condition :

IsoWeekNumber([Due Date])=IsoWeekNumber(Today())+1

Configure it the way you want !

🍽️Second Step : Digest the data, and prepare your mail !

Then, we would like to digest the data, in order to start thinking about a mail body. For that, we can use ForEach() function, in something like this :

([RemindedTask].Filter([DD_Tomorrow]=1),CurrentValue.ToText()).BulletedList()

that would render :

⁠

Eat Fajitas Important Meeting Build a new dam Clean my data Secret Stuff

⁠

Finally, with Format() or Concatenate() function, you can also prepare the body of your mail :

Concatenate("👋 Hi Quentin !",Character(10), "Tomorrow you'll have to complete the following tasks",ForEach(RemindedTask.Filter(DD_Tomorrow=1),CurrentValue.ToText()).BulletedList(),Character(10),"Good Luck !")

That would render :

⁠

👋 Hi Quentin ! Tomorrow you'll have to complete the following tasks Eat Fajitas Important Meeting Build a new dam Clean my data Secret Stuff Good Luck !

⁠

🤖 Final Step : Prepare a “Send Mail Button” and based-on-time automate it !

Next step : just create a button like this

Send me tomorrow's task

⁠

, configured with

gmail-pack⁠

email sending formula, with an easy configuration easy like this :

⁠

To finish, create a time-based automation, that will push the button each day at the evening, so that you will know your task/meeting of tomorrow ! 😁

⁠

🦸‍♂️ Super Hero Bonus : Super Power Digest Your Data

With a little practice, you can digest and compile your most complex data in some cool way, playing like this :

Detailed Reminded Task

Detailed Reminded Task

Task

Due Date

People

Project

Call Mister B.

9/29/2022

Bobby

Eat Fajitas

9/30/2022

Bobby

Important Meeting

9/30/2022

Ernesto

Build a new dam

9/30/2022

Bobby

Throw my phone

9/16/2022

Bobby

Clean my data

9/30/2022

Ernesto

Secret Stuff

9/30/2022

Tom Cruise

There are no rows in this table

⁠

Project

Job

Personnal

Top Secret

There are no rows in this table

⁠

Concatenate("👋 Hi Quentin !",Character(10), "Tomorrow you'll have to complete the following tasks",character(10),ForEach(

Projects,

Concatenate(

_color("Red", _bold(CurrentValue.ToText())),

ForEach(

RemindedTask.Filter(Project = CurrentValue AND DD_Tomorrow=1),

Concatenate(

CurrentValue.Task.ToText(),

" with ",

_color("Blue", CurrentValue.People)

)

.BulletedList()

)

.BulletedList(),Character(10),"Good Luck 🍀")

⁠

👋 Hi Quentin ! Tomorrow you'll have to complete the following tasks Job Build a new dam with Bobby Clean my data with Ernesto Personnal Eat Fajitas with Bobby Important Meeting with Ernesto Top Secret Secret Stuff with Tom Cruise Good Luck 🍀