Why when I try to add a condition or an action or anything the choice is only to pick from the User Table?

have just started with Glide, trying to figure out the logic. So I have a table with some calender events which I would liket to show in my app in a calender view and also a list view for each day. And in the day view I can’t figure out how to limit the list to the day view only. I use a custom empty screen and picked the “list” in the collection. The setting are only allowing me to choose from User data table. Why can’t I choose from my events data table?

Might need some screenshots to better understand what you are trying to do. Show how you are trying to filter the collection. Also, which table is your screen attached to?


Check this here. I have my values taken from “Keto…” data table, but the I only can set up the visibility from the values from the “User” table. WHy is that?

You are trying to set visibility on the tab itself. That will control if the entire tab is shown or hidden, and only relies on values in the user profile. You should instead have the collection selected. Once selected, you want to set a filter for that collection.

Only set visibility if you want the entire collection to be shown or hidden. The filter will control the contents inside of the collection.

1 Like

OK, I’ll try the filter instead.

1 Like


I’ve seen somewhere in the tutorials that I can use formulas to set the current date, but it doesn’t work here. where can I find the list of formulas which are working with these setups and filters?

You can’t enter formulas in the filter, but you don’t need a formula. Change ‘Is’ to ‘Is Within’ and then select Today.

when I choose “is within” and “today”, it showes me the list for tomorrow

Just for clarification, do you have Respect Timezone selected in the configuration for the date column in the data editor? How are the dates populated with values in your table? It should work, but maybe I’m missing an important detail. Sometimes your timezone can cause unexpected results.

There is another alternative that should work. In your table you can create a math column that will give you the current date and time. All you need to do is add a formula, such as ’NOW’ or something as simple as ‘X’ and then set up a replacement in the math column to replace ‘X’ with Now. This will give you the current date and time which updates every 10 seconds in the table. Then you can change your filter to compare the date column to the math column.

1 Like