# Automation Triggered by Calculated Date

I’m trying to create an automated notification based on whether a calculated date is equal to day. In other words, I’d like to be notified when the calculated “remind me” date is today. I don’t see an existing topic on this, but may have just missed it. Thanks for any guidance!

Hey there!

You can just make an automation that runs every day - and then put an if() condition that reads whether or not your column = today()

If it’s not, no harm no foul! Nothin will run. But if today()= the value in your table, it will run and notify you.

Try it out! Let me know if you need more help

2 Likes

Hi Scott. Thank you. I can’t quite figure out the right formula after numerous attempts. Any quick thoughts as to what would work? Appreciate the guidance.

Can you throw up a quick screenshot of the table/location where your calculated date is? Happy to give an example after that!

Attached is the screenshot, Scott. It’s a little medication tracker I’m using for my mom, where when the Remind value for the unfilled Rx becomes today( ) then that should trigger a notification. Step 2 of the automation is: [Med Tracker].Filter(currentvalue.Remind = Today()) but I don’t think this is quite right. Thanks for the assist.

Jeb

Glad to help out!

Step 1: Crete an automation to go off every day

Screenshot

Step 2: Write an `If()` condition to check if todays date is in your date column

In this step you are going to check if a singular value (todays date) is inside of a list. The list you will be comparing it against is the date column inside your table. Columns are lists of values and Codas In() formula allows you to simply check whether or not a value is in a list.

This formula will result to either `True` or `False` - Your automation will only run if it results to `True` (aka if Todays date is indeed inside your date column)

Screenshot

Step 3: Write the `Then` statement to send a notification with a summary of the columns that are due for reminders

While you don’t need to do this, I often like to hold my notification message (as a template) in a separate table. Makes it easier, especially as your notifications become more complex/conditional and especially if you end up sending you notifications as emails through the gmail/outlook pack

Screenshot

Heres the document if you need it!

3 Likes

Scott, your response is absolutely amazing. Works like a charm. I’m still getting used to the ‘chaining’ of Coda formulas (so used to Sheets and Excel), but I’m getting the hang of it now. Thank you thank you thank you. Jeb

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.