Is it possible to automatically show today's record based on month and day?

Ask for Help
1

Hello everyone,

I’m trying to build a simple devotional app in Glide and I’m wondering if the following use case is possible.

I have a table called “Andachten final” with 366 rows (one for each day of the year, including Feb 29).

Relevant columns:

  • month_num (1–12)
  • day (1–31)
  • plus the devotional content

Example:

month_num day title
1 1 SEGEN
1 2 TRIUMPH
3 7 …

What I want is very simple:

The app should automatically show the record for the current day.

Example:

  • March 7 → show row where month_num = 3 and day = 7
  • March 8 → show row where month_num = 3 and day = 8

In other words something like:

month_num = current month
AND
day = current day

I already tried several approaches with ChatGPT and Gemini (using things like Date/Time columns, Extract Date Part, relations, etc.), but I couldn’t get a reliable solution.

Before spending more time experimenting, I wanted to ask:

Is this a supported/typical pattern in Glide, and if so what is the recommended way to implement it?

Thanks in advance!

Patrick

1 Like
2
  • Create two math columns using the following:
    – Month(Now) : will give you the current Month number
    – Day(Now) : will give you the current Day (of month) number
  • In both cases above, use the special “Now” value as a replacement
  • Now create a Query column that targets your Andachten final table, and apply two filters:
    – month_num equals This row → “first math column”
    – day equals This row → “second math column”
  • Ensure that your Query column does not have “Match multiple” selected
  • Finally, use a Lookup column to fetch the content for the matched day
4 Likes
3

Hi,
I have experienced problems when using dates as a filtering measure, there is a video from @Robert_Petitto , where it provides a formula where it converts the date into numbers, to achieve exact filtering, Attached Formula: year(today)*10000 + month(today)*100 + day(today)

2 Likes
4

That’s not relevant in this case as date values are not being used as filters (numbers are).

3 Likes