There have been a few weird issues I’ve been running into since last week.
First, people are constantly having to refresh their browser for things to work. They’ll press a button and it’ll work as expected, then they’ll press the next one and they’ll get an error & have to refresh the page.
Second, some formulas are not working as intended. For example, these columns should be equal, they’re exactly the same, both are date columns.
The formula for Dates are Equal is: thisRow.Date=thisRow.[Test Date]
If I add .todate() to the Date column, it becomes true, but I shouldn’t need to do that.
HI @Samuel_Langford
The ‘thisRow’ is the object and that explains why you need to add ‘ToDate()’.
Does this make sense to you, if not feel free to ask
Cheers, Christiaan
I don’t really understand what you mean, column columns are dates, so shouldn’t thisrow.date and thisrow.test date both spit out dates?
hi @Samuel_Langford ,
it is likely less evident than I initially assumed. Let me try to explain this with a screenshot. Below you see the base table and then the two formula variations. One with the thisRow and one with a reference to the column.
When you write thisRow, Coda looks at the entire row object—a complete bundle containing all fields for that record (Name, the date, check, Notes)—which is why comparing thisRow = [the date] returns false, as a whole row object is never equal to a single date value. By contrast, writing [Name] = [the date] compares the specific value inside one cell directly against the value in another; since both cells contain the same date, Coda evaluates the statement as true. Think of thisRow as an entire ID card and [Name] as a single line on it: comparing thisRow to a date is like asking if the physical ID card is a date, whereas comparing two columns checks if two specific pieces of information on that card match.
I hope it helps, cheers, Christiaan
