Quote:
Originally Posted by capink
Create a composite column with the following template:
Code:
{#custom_date:'ifempty($, field('timestamp'))'}
replace #custom_date with the name of your custom column. And choose sort column by date. This column will show the value of the #custom_date and if not found will substitute it with timestamp. |
Thank you! I keep forgetting how ridiculously powerful Calibre is. I'm used to thinking of book cataloging software as being really limited. But that just doesn't apply here.
And in fact, this is actually the perfect solution for me. With my old program I only added a book when I was ready to review it. So the timestamp == review date. But I actually put ebooks into Calibre before I review them. So my date was always going to be a bit off. With this solution I can choose to set a more exact date if I want to (and will set it automatically for older books from import) or leave it empty and let it be calculated from the timestamp if I do not. This appeals to the fastidious nitpicker in me.
But I am also grateful for the pointer to the metadata bulk update. Because if I were slightly less... well me.... this would have been a very sensible solution.