Choices with dynamic dates

Ask for Help
1

image
image1438×504 46.2 KB

Hello, good afternoon everyone. I’m back here. Yesterday, Jeff helped me implement the following:

I needed to have the days of the month present, so for example, if today is March 29, 2025

then it will show them in each row:

  • March 29, 2025
  • March 30, 2025
  • March 31, 2025

And so for the following months, where it will only show me the current month, I already achieved that. After that, I’ll show those dates in a selection.

But the following happens to me, when I select the choice with the dates already established from my table that I previously showed, then it only lasts a while and then is deselected, it is as if the selection is not fixed and I think it may be because of the format that I am handling the dates since the dates are added with the formula in the “Dates” column Now + x then because of the time change that Now is having, so that is why I think it is not left selected.

image
image1057×746 46.8 KB

image
image367×280 15.9 KB

image
image380×287 14.5 KB

2

You are correct. A date column always has an underlying time and since that time changes every 10 seconds due to using ‘now’, you no longer have a matching selection. Try adding a template column to the choice table to lock in the date as text (without the underlying time). Then use that template column for your choice component. I think that should work.

There are other alternatives, such as splitting the date into separate Year, Month, Day columns and putting them back together…or using math to format the date as YYYYMMDD…but I think the template trick should work fine.

3

You’re right, the template column now takes those dates as “Fixed” and not with the time that caused me that inconvenience, as the time change produced that “deselection”. Thank you very much again Jeff! Saving me once again and learning every day with the Glide community <3 :100: