Auto-generated next actions

[holroy]

It’s doable, and it has been done before, so see something like the following:

Dataview Table - Display only first uncomplete task on a page

That is the problem of just give you a solution without context and previous attempts. In the case you’ve no idea of the consequences of the command “GROUP BY” in the query. The code has a order of commands, and some commands have consequences in the data structure on the background. The final reflection of that process is in the initial lines (the lines that define the columns, the last thing to consider in a table query). The command GROUP BY something produces two things: the key (the some…