I use Coda to host a points tracking system for my students. Someone behaves well, I give them a point. The point is recorded as a row in a table, like a transaction on a ledger.
Student | Date | Point |
---|---|---|
13 May 2025 | -1 | |
J | 13 May 2025 | -1 |
J | 13 May 2025 | -1 |
D | 14 May 2025 | 1 |
T | 14 May 2025 | 1 |
D | 14 May 2025 | 1 |
D | 14 May 2025 | 1 |
Points for each student are totalled up in a column on the main roster table, by this formula:
sum([Student Points].Filter(Student = thisRow.Name).Point)
And points awarded today (eg. in this class) are tracked with this one:
sum([Student Points].Filter(Student = thisRow.Name).Filter(Date = Today()).Point)
Now, I recently set up a separate set of points, with the exact same set up, this one for doing their homework. Here’s the points total formula, which works:
sum([Academic Points] .Filter(Name = thisRow.Name).Point )
However the “points today” formula is malfunctioning. Its column is all zeroes:
sum([Academic Points].Filter(Name = thisRow.Name).Filter([Academic Points].Date = [Academic Points].Today).Point)
I even set up a ‘date’ and ‘today’ column on the points table, just to expose the values:
Name | Date | Point | Today |
---|---|---|---|
A | 14 May 2025 | 1 | 14 May 2025 |
D | 13 May 2025 | 1 | 14 May 2025 |
A | 14 May 2025 | 1 | 14 May 2025 |
T | 14 May 2025 | 1 | 14 May 2025 |
For some reason, Filter.(Points.date=today())
works for one column’s formula, but returns no values on the other.