Create a valid Date with Month an Year Columns

Hi Guys, I’m from Germany and i hope you understand what i want to create:
I have a Table with seperate “Month” and “Year” column. Both are Number-Types.
At the end of the day I will create a popup when reach the Date.
For example: Column “Month” is 8, Column “Year” is 2026, i will have a popup message on first of August 2026 with a reminder.
How can i create this? Thanks in advance
Mario

Hi Mario, welcome to Glide.

I believe that what you really want is to have a reminder that pops up when we actually reach that month (for example: show a message on 01/08/2026 when Month = 8 and Year = 2026).

What type of “popup” do you want for your case? Is it an in-app banner, or an email, or something else?

1 Like

Hi! Thanks for your answer.
Your thoughts are totally right!
Hmm, maybe like a notification on the phone screen? Or email, or WhatsApp?
Some of them (first one prefer) that can work with GlideApps only.

It’s a little privat app for Inspections and all other Datas of my Cars and my family cars and it should help me, not to forget any two-years-inspection called TÜV. :slight_smile:

Email integration would be the easier, there are plenty of native email integration and actions available.

WhatsApp message: I know how to open a message thread from a Glide app via a user interaction, but I don’t know how to schedule a message to WhatsApp.

Push notification are technically possible but not easy to implement, I wouldn’t recommend it for your use case.

And an in-app banner on the homescreen would also be possible.

In-app banner would be the easiest to implement in Glide:

  • You show a banner or warning component on your home screen.
  • It only becomes visible when the current date is on or after the 1st of the target month and year.
  • You store Month and Year in your table, build a computed Date from those, then create a condition like:
    • “Today ≥ Reminder Date” AND “Read IS NOT true”
  • The main limitation is that you still need to open the app for the reminder to show, which might defeat the purpose if you forget to open it.

For the “Read” boolean:

  • Use it as a simple “dismissed” flag for each reminder row.
  • Add a button like “OK” or “Got it” on the banner.
  • When the user taps it, set “Read” to true in that row.
  • Because your visibility condition checks “Read IS NOT true”, the banner will automatically disappear and stay hidden once it has been acknowledged.

As Nathanael mentioned above, push notifications are not supported natively today:

  • They are technically possible with workarounds (PWA + custom notification service, external backend, etc.).
  • However, you would have to jump through a lot of obstacles for something that should be a simple reminder.
  • If you are curious, here is a community tutorial that goes deeper into that approach.

For WhatsApp, you would likely need a third-party automation tool such as Make.com:

  • Your Glide app writes reminders into a “Notifications” table (like you suggested in your original post).
  • In Make, you schedule a scenario to run on a fixed frequency, for example every 1st day of the month.
  • Each run, the scenario looks at the “Notifications” table for any rows where the reminder date is “today”.
  • For each matching row, Make sends a WhatsApp message through WhatsApp Business Cloud or another WhatsApp provider.

So in short:

  • In-app banner is the simplest and stays fully inside Glide, but still requires opening the app.
  • Push notifications are technically possible but advanced and not recommended for this use case.
  • WhatsApp reminders are doable if you are comfortable setting up a small Make scenario that checks your reminder table on a schedule and sends out messages.

You can also explore sending WhatsApp messages using a Twilio integration.