Moving dateless todos to the end of the list is now possible


Custom CSS is now available via a dialog that can be opened from the agenda menu

Anyone successfully have Agenda running in Windows 11? I have been using it for quite some time on Windows 10, but after setting up a Windows 11 machine I am unable to get the Agenda plugin to show up. Appears to be a SQLITE error, but it seems to only be on the Windows 11 machine.

Trying to install Agenda 3.7.0 on Joplin 2.8.4

2022-04-25 13:35:51: joplin.plugins: "Uncaught exception in plugin "com.gitlab.BeatLink.joplin-plugin-agenda":", "Error: SQLITE_ERROR: duplicate column name: sortOrder
Error: SQLITE_ERROR: duplicate column name: sortOrder"

I have the same error as Comfortably_Dumb1979 above on OpenSuse Tumbleweed after updating to Joplin 2.7.15 (appimage).

I've tried removing the plugin from the .config/joplin-desktop directory and even went so far as to completely remove the joplin-desktop config directory to start from scratch but still have the same issue and message with a clean installation.

2022-05-01 10:43:14: joplin.plugins: "Uncaught exception in plugin "com.gitlab.BeatLink.joplin-plugin-agenda":", "Error: SQLITE_ERROR: duplicate column name: sortOrder
Error: SQLITE_ERROR: duplicate column name: sortOrder"

Hey everyone. Apologies for the error but I think i know whats causing it and I will have a fix out by the end of the day

The issue should be resolved on upgrade to 3.7.1

The detailed cause of the problem was that as features got added to agenda, the database needed to be upgraded to accommodate more information. My previous fix was to use an internal database version number to determine whether the needed database columns were added but that lead to the problems you guys were facing where the new columns (like sortOrder) were already added but the database version wasnt updated, causing the error and crashing the plugin.

My new solution is to forego the database versions and just check directly whether the column names exist in the database and if they arent, to add them then and there. This should solve the problem.

1 Like

Working again now.

Thank you!

I can confirm it is working for me again, thank you for your work.

Is it possible to change the font (size, color) using custom css?
What is the syntax?

Thank you for your good work on Agenda. I think you have made a super useful plugin, and in conjunction with the Recurring Todos plugin it is working well for me.

What's missing is syncing with Calendar apps. I was wondering whether a feature that creates an ics file from the summary note would be feasible. Then any Calendar app could display it. One way sync is sufficient in my opinion because if you need two way sync you probably should use Todoist or perhaps Fantastical. Hence the ics suggestion as a simple fix.

I don't know the ins and outs of how Calendar sync works, so my suggestion may be completely stupid. No harm in asking though?

1 Like

yes, i know very little CSS and managed to bash together something and im pretty happy with it looks.

What i really am dying for is a way to color code tasks in the agenda panel based on tags or notebooks or however it might work

This would require adding tag based html classes to each task element. It's doable, but free time is scarce on my part.

As Glyn stated, there is always a scrollbar shown even if it is not needed (the scrollbar just appears in grey as in the screenshot of atomicangel ). Hiding these scrollbars when no scrollbar is needed will save space and declutter the UI.

Except that, the best plugin out there!

Hey guys, sorry I haven't been around much. Been very busy IRL

But for a quick and dirty fix to the scrollbar, you can add custom CSS for the panel via menu options. Paste this code and it should work.

/* hide scrollbar but allow scrolling */
body {
    -ms-overflow-style: none; /* for Internet Explorer, Edge */
    scrollbar-width: none; /* for Firefox */
    overflow-y: scroll; 

body::-webkit-scrollbar {
    display: none; /* for Chrome, Safari, and Opera */

CSS noob here. What am I doing wrong with this to make the agenda text smaller in the sidebar?
(Note that I'm putting this in the Agenda -> Set Panel CSS)

#agendaTodo {
font-size: 12px;
letter-spacing: 0.5px;
word-spacing: 0.5px;

Thanks for Agenda and Repeating To-Dos! They're just what I've needed since moving to Joplin. One minor bug...

On Joplin Desktop 2.8.8 the top of the profile settings popup is chopped of if the Joplin window is not large enough to accomodate the entire popup. It's possible to scroll down to the bottom of the popup, but not up to the top.

Thanks again.

Love your plugin! It is exactly what I wanted to help Joplin organize my todos.

I have two suggestions:

  1. Remember Agenda panel size when toggling
    The agenda panel takes about half the editor space by default. I usually resize it by dragging so that it is much smaller. I also like to toggle the panel to hide it when I want to focus on a specific note. After making it visible again it shows with the default size. I'd like it to remember how I had resized it so that it will always show that when toggled to visible.

Another option would be an easy way to change the default sizing. I don't know if that is easy to do with custom css

  1. Add ISO Date as a date format option. So today's date would be 2022-08-22 for example. A nice way to do it is using the Canadian locale which apparently uses ISO! toLocaleDateString('en-ca')

Edit: Btw a great combo plugin for all Joplin todoers is "auto alarm" so you can easily set the due date/alarm on a task with context sensitive language AKA in a week or tomorrow morning

1 Like