Cannot filter Data Grid by computed If-Then-Else column (current month)

Ask for Help
1

Hi,

I have a table called “Koledar” with a proper Date column.

I also created a computed column:

  • is_tekoci_mesec (If → Then → Else)
    This column returns true when the row date is in the current month.

Problem:
When I try to filter a Data Grid, Glide does not allow selecting
the computed column (If-Then-Else) in the Filter Data options.

I understand that computed columns might not be filterable,
but I want to confirm the best practice.

Questions:

  1. Is it correct that Data Grid filters only work with basic (non-computed) columns?
  2. Is the recommended approach to always filter directly by the Date column
    using “date is in This month”?
  3. Is there any supported way to use a computed boolean for filtering,
    without copying its value into a physical column?

Thanks!

2

Sounds like you’re using a Big Tables for the relevant table here. Can you confirm?

3

Yes, i use big tables.

4

So what you’re experiencing is a calculation limitation of Big Tables.

I think you may want to try establishing 2 math columns in your Users table (not a Big Table), then try filtering your basic Date column to be on or after the “Month Start” date and on or before the “Month End” date to see if it allows you to do so.

1 Like
5

Thank you, it works in a Blank Table and it also works with an If-Then-Else column.

6

So you can confirm it works normally when you created a new Glide Table (not Big Tables)?

7

Yes, works normaly.

1 Like