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.