Custom list template

[Laval]

Hello I thank you for your reply. I would have one last question, I created a custom list template in my content server like this "Number {series_index} series {series}" and I would like to have the total number of books (5 in my example below) of the series. Ex: "Number 2 of 5 of the series (name of the series)".

Thank you!

[PeterT]

As far as I know it's not doable.

Sent from my Nexus 7 using Tapatalk

[filmgal]

That's too bad. I would like this feature as well.

[RomanukcJdi]

Hmm, a very interesting question, I know that such a list can be made in the usual Notes application on an iPhone.

[RomanukcJdi]

But with a computer it's a bit more complicated. If I'm not mistaken, it is simply impossible to do it on a computer. But there is one interesting way out, such a list can be made using a standard template. At work I needed to find a list template of a certain format, thank goodness that my friend advised me a site to do list template, where many formats of templates are collected. So I recommend you to look for something like this too, and then you can find the right template for your content service. Good luck.

[wiso]

Originally Posted by Laval

Hello I thank you for your reply. I would have one last question, I created a custom list template in my content server like this "Number {series_index} series {series}" and I would like to have the total number of books (5 in my example below) of the series. Ex: "Number 2 of 5 of the series (name of the series)".

Thank you!

caliber knows the number of books in each series, but cannot access those values? why?



You can see the number of books in each series from the series tab in the gui or in manage series.

A crappy solution that I am using is to use the "Author Book Count" plugin (which counts ALL the books of an author, not of the series, but it is an approximation) with this I create a custom column that shows the number of books of the author in the columns of the books that belong to a series.

I leave you this personalized column in case you are interested.

##### config to display a column with the title [serial no./total serial no.] -> dune [01/3]

#author_book_count column  (### you should hide this column ###)
has the number of books per author (using the Author Book Count plugin)

column #is_series (### you should hide this column ###)
(obviously, for books that do not belong to any series, it counts them as series of 1 book, we are not interested in that)
(that's why this column is hidden and will serve as an auxiliary column, to show this information only if it belongs to a series)
{series} [{series_index:0>2s}/{#author_book_count}]

column #series_total  (### this is the kind of column you are loking for !! ###)
(if the column 'series' is blank #series_total is left blank, otherwise we put what the column #is_series says)
program:
  if field('series')==''
    then ''
  else
    field('#is_series')
fi

You will see in the new column

Title [actual book with 2 digits format filled with 0 / Total serie books]

Example:
Dune [01/3]

[Katja_hbg]

I just play around a bit and found a solution to show series "a of x"
But this maybe a performance issue and should not be used for a big library or only for subsets and in (normally) hidden columns.
There are a lot of example in the forum for number-format tweaking, if needed.

1. Preferences - Advanced - Tweaks - set "allow_template_database_functions_in_composit es = True" (only available with Calibre 6 and up)

2. Add column - "column built from other columns" and output "text"

3. Copy this code into the column template:

program: 
# Returns the series_index together with the last number in a series (or nothing for book with no series),  e.g. [2/5]

if field('series') then 
   this_series = field('series');
   books_in_series = book_values('title', 'series:="' & this_series & '"', ',', 0);
   highest_series_num = 0;	
   for title in books_in_series:
	title_index = book_values('series_index', 'title:="' & title & '"', ',', 0);
	if title_index > highest_series_num then
	    highest_series_num = title_index
	fi
    rof;
    series_idx_max = "["&field('series_index')&"/"&highest_series_num&"]"
else
    series_idx_max = ""
fi;
output = series_idx_max