You’re not alone, if it can re-assure you a little .
Today() to disable a very simple
ModifyRows() button and I need to refresh my doc between 3 to 5 times (or more some days) before
Today() does what it needs to do …
The thing is that it’s kind of inconsistent and I’m not able to find the steps to reproduce this behavior 100% of the time (some days,
Today() will be refresh faster than others)
I’ve tried cleaning cache & cookies, but it doesn’t change a thing…
Today() seems stuck somewhere when I open Chrome in the morning and this doc is loaded, as I voluntarily quit Chrome at the end of the day on that doc so it’s the first thing I’ll see the next morning.
The strange thing with this is that sometimes, when my doc is still opened and it’s actually passed midnight,
Today() will work and my button is enable again… But if I don’t click on my button and quit Chrome, the next morning I’ll still have troubles to make
Here’s a screenshot of my problematic button in the table :
The button is in the field
[Set Today] and date field next to it is just classical
Date field (manual entry).
All I’m asking this button to do is to modify the date in the date field and set it to
Today() using this very simple action formula :
The button is then disabled using this formula:
The button works as it should as long as I don’t use a formula to disable it … But I actually would like to be able to disable it once its job is done.
I’ll admit, as it’s a “draft” doc that there are a bunch of tables, quite some complicated formulas stored within buttons and some conditional formatting, but it shouldn’t matter …
I’ve tried everything I could think of in the disable if formula :
thisRow.Date.ToDate() = Today()
thisRow.Date = Today().ToDate()
thisRow.Date.ToDate() = Today().ToDate()
But this also didn’t solve the issue :
Today() is hard to refresh and is kind of preventing me to use that button the way I would like
Maybe I’m completely missing something here though , but it’s not the first time I use a similar setup and never encountered such issues before (as far as I can remember)
I had the intention to re-use the date set by my
Set Today button elsewhere in my doc but I honestly just stopped there (because of some time issues but also well, because of this )