Making a column to organise audiobooks

[serpi]

I have a bunch of audiobooks I want to throw into calibre to keep them organised in one place, but I want to have a column filter to be able to easily organise them.

Any suggestions on how I can get a column filter to pick up a certain format and organise them. Could I just tag them audiobook and get a column to filter that tag?

[serpi]

figured a way out, how do I delete this thread?

[dunhill]

It would be better to put the solution so that it can be used by another user.

For example, I have a custom column that depends on another column.
Query name: audio_only
Column Heading: Audio Only
Template:
program:cmp(count(template('[[format]]'), ','), 1, 'no', in_list(template('[[format]]'), ',', 'Ogg', ' Yes', 'no', ',', 'M3u', 'Yes', 'no', ',', 'M4a', 'Yes', 'no', ',', 'Mp3', 'Yes' , 'no')

[serpi]

Originally Posted by dunhill

It would be better to put the solution so that it can be used by another user.

For example, I have a custom column that depends on another column.
Query name: audio_only
Column Heading: Audio Only
Template:
program:cmp(count(template('[[format]]'), ','), 1, 'no', in_list(template('[[format]]'), ',', 'Ogg', ' Yes', 'no', ',', 'M3u', 'Yes', 'no', ',', 'M4a', 'Yes', 'no', ',', 'Mp3', 'Yes' , 'no')

I followed this answer I found on Quora complete credit to Peter Comeau

"You create new categories in the Tag Browser, that is the list of Tags in the bar on the left side of Calibre.

At the bottom of this bar is a button ‘Configure’.

Click that button and choose ‘Manage…’

From the list select ‘User Categories’

In the empty text box at the top type the name you want to give your Category. Then click the ‘+’ button

Now you can add books by Author, Series, Publisher, or Tags from the selection on the left side. Use the drop down Category Selector to choose between these filters.

To add a book, highlight your selection and click the ‘>’ Arrow button.

Click OK and your new Category will appear in the Tag Browser bar."

[wiso]

There are many ways of doing it.

1) As dunhill has said

2) Same, but with a list of formats.

program:
my_formats = 'Ogg,M3u,M4a,M4b,Mp3,Aac,Ac3,Zip,Rar';
if list_intersection(lowercase($formats), my_formats, ',') then
'Yes'
else
'Nope'
fi

3) Directly display the format

In any case, add new rules in the /preferences/appearance/icons column to add distinctive icons for books, audiobooks, or whatever we save in caliber.

P.S: You can edit your custom column duration or use AudioBook_Duration plugin for that

[theducks]

Originally Posted by wiso

There are many ways of doing it.

1) as dunhill has said

2) same, but with a list of formats.

program:
my_formats = 'Ogg,M3u,M4a,M4b,Mp3,Aac,Ac3,Zip,Rar';
if list_intersection(lowercase($formats), my_formats, ',') then
'Yes'
else
'Nope'
fi

3) directly display the format

In any case, add new rules in the /preferences/appearance/icons column to add distinctive icons for books, audiobooks, or whatever we save in caliber.

P.S: You can edit your custom column duration or use AudioBook_Duration plugin for that

Your list includes 2 'formats' that already have use as e-Books (Rar, Zip)
I woner if Kovid could add a FOL (folder) so you could drop (add to FOL) Audio/Video into the FOL, even if they had the same extension used by books.