List all your assignments and highlight those that are overdue by coloring them in red

List pages with due date and color those overdue¶

Basic¶

TABLE choice(due < date(today), "<span style='color: red;'>" + due + "</span>", due) AS "Due"
from "10 Example Data/assignments"
SORT due asc

Variants¶

Add an additional emoji in front of the link¶

Useful when you display more meta data or sort after another property.

TABLE WITHOUT ID choice(due < date(today), "🛑 " + file.link, " ⚫ " + file.link) AS "Assignment", received, class, choice(due < date(today), "<span style='color: red;'>" + due + "</span>", due) AS "Due"
from "10 Example Data/assignments"
SORT class asc