View Single Post
Old 04-12-2020, 03:08 PM   #16
Skydog
Wizard
Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.
 
Skydog's Avatar
 
Posts: 2,286
Karma: 7409537
Join Date: Mar 2009
Location: Circling Earth @ Mach .83
Device: Elipsa 2E, Sage, Libra Colour, Libra 2, Clara 2E, Oasis3, Voyage
Quote:
Originally Posted by davidfor View Post
One of the versions of code I posted should do what you want. You need to change the name of the column it uses to your column. That means changing where I have "timestamp" to "#finished". Then in the definition of the column, tick the "Show in Tag browser" option. That will show an entry for the new column with the count of books with a value in it. But, that number isn't the number of books that have a value in that column (and hence in #finished). It is the number of different values in the column. Clicking the heading in the tag browser will show the books with a value in it, and show the count of books in the status area at the bottom of the calibre window.
Thank you, davidfor. Even with your detailed explanation I failed. I copied/pasted your program, with changes, to the template field of the new composite column as shown below:

format_date(raw_field('#finished'),'MMM.yyyy')

Something is wrong since it created a new (Read) column and populated every line in my library with the the program as written above. Also, it wiped out all my existing "Finished" entries while recoloring all my books (instead of only those that have been finished, as I have customized). I deleted the attempted column and all has returned to normal.

The new "Read" column appeared in the tag browser but when clicked on, it displayed the program. BTW, what should be selected in the "Sort/Search column by" field? I had Date selected but it appears selecting other options had no effect.

Clearly, I am clueless.
Skydog is offline   Reply With Quote