How to Set up a Calendar Reminder

[Stacie_Pineda]

I use Airtable in a very basic way. The only integration I have is via Zapier and emails. No formulas at this time. Is there a way to incorporate a calendar that will send a reminder. In my real estate business I will have certain dates that require attention in keeping the transaction on track. I’d like those dates to ding, ring, clang as reminders across email, on airtable, etc. This seems so elementary so surely I’m missing something?

[Elias_Gomez_Sai]

I’d suggest to create a View to Filter those records, and automate a reminder with Zapier or Integromat.

[Stacie_Pineda]

How do I create a “View to Filter”?

[Patrick_Ford1]

Hi Stacie, You can create a different view that filters out fields you don’t want to see. But I don’t think this is necessary for simple reminders. You will need a date field though for Zapier to look at. You could also create a formula field that says: “If the difference between today and the due date is within 30 days, then set the field to ‘Needs Review!’” Then a Zapier integration could watch records with the “Need Review!” tag and send you an email notification whenever it finds one.

[Patrick_Ford1]

IF(DATETIMEDIFF(TODAY(), {Your Date Field}, 'days') <= 30, "Needs Review!", "Looks Good")

[Stacie_Pineda]

Is it just me or is this a fairly complicated process? Why doesn’t Airtable just have a built in reminder/calendar?

[Elias_Gomez_Sai]

Stacie_Pineda:

How do I create a “View to Filter”?

Airtable - Support

Guide to views

This article provides an overview of views within Airtable—what they are, why they're important, and how to make new ones. This article is primarily focused on grid views—to learn more about our ot...

Patrick_Ford1:

Then a Zapier integration could watch records with the “Need Review!” tag and send you an email notification whenever it finds one.

So you make the filter on Zapier? I think it’s cleaner with a View because you does not need the extra field (unless you have too few fields and too much views).

Stacie_Pineda:

Why doesn’t Airtable just have a built in reminder/calendar?

You have Calendar type for Views, but it has no reminders:

Airtable - Support

Guide to calendar view

If you have at least one date field in your table, you can create a calendar view. Calendar views (as you might guess) allow you to look at your records on a calendar. Users on Pro plans have acces...

You can suscribe to the iCal link that the View offers, and then configure Reminders in your calendar app:

Airtable - Support

Integrating Airtable with external calendar applications (e.g. Google Calendar,...

Want to export the events in an Airtable base to your favorite calendar app, such as Google Calendar, Fantastical, or Outlook? You can get an iCal link from a shared calendar view, and if you subsc...

[Jesse_DigitalFu]

Hey Stacie!

I specialize in workflow automation in real estate and can definitely help out with what you’re asking about here. Do you have 15 minutes to hop on a call so we can screen-share and I can walk you through this?

Feel free to shoot me an email at jesse@digitalfusion.io and we can set something up. :slightly_smiling_face:

Cheers!
Jesse

[Ludwig_Coleman]

A software that offers to do so much…but doesn’t offer a calendar reminder. WHAT A JOKE

[Justin_Barrett]

If we were talking about a calendar application, I would agree. However, we’re talking about a database, and calendar reminders are not (to my knowledge) commonly part of database software. While Airtable does have a calendar view, it’s not intended to act as, or replace, a fully-functional calendar application. To my knowledge, the devs have never even hinted at Airtable’s calendar acting as a replacement for a dedicated calendar app.