Column showing book formats

Calibre26 · 08-07-2021, 05:09 PM

The only threads I found were from 10 years ago. And there seems to be more options now. In Lookup name I entered Format. In column heading I entered Formats. In column type I chose column built from other columns (although there is an option with behaves like tags). I have no idea what else to fill in. Have I done the right thing to get a column showing all my books and their formats?

BetterRed · 08-07-2021, 06:11 PM

Click image for larger version

Name: Screenshot 2021-08-08 080836.jpg
Views: 134
Size: 113.1 KB
ID: 188583

BR

Calibre26 · 08-07-2021, 06:43 PM

BetterRed, that's fantastic, thank you. Didn't expect it to be so straightforward.
Great name btw.

kenmac999 · 08-08-2021, 01:05 PM

Are you wanting a column that displays all the formats with another field(s) or a custom column that shows how many (number) different formats of a particular book you have?

I created 3 custom columns that I call "Formats", "Location" and "All Formats"(column heading)

"Formats" (created using quick create option)

Code:

Lookup name: formats 
Column heading: Formats
Column type: Column built from other columns
Description: eBook Formats available
Template: {formats}

"Location"

Code:

Lookup name: locate 
Column heading: Location
Column type: Text, column shown in the Tag browser
Description: Shelf location of physical books or whether it is an Audiobook
Template: {formats}

"All Formats"

Code:

Lookup name: mod_format
Column heading: All Formats
Column type: Column built from other columns
Description: Combines informat from Formats and Location columns
Template: {:'approximate_formats()'} {#locate}

I only display the "All Formats" column. I can quickly glance at the All Formats column to see what format my ebooks are in (AZW(3), EPUB, MOBI, PDB, PDF) or if I also have an audiobook or physical edition also.

Since I started collecting books over 40 years ago I am trying to slowly replace my physical books with audio and ebooks. I love reading physical books but I also enjoy the convenience of carrying ebooks and audiobooks on my phone. Some weeks I will be reading 3 different books depending on where/what I am doing.

Calibre26 · 08-08-2021, 02:12 PM

Kenmac999 it was just a column showing each book's format at a glance. But thanks for the ideas.

dunhill · 08-08-2021, 04:23 PM

This is due to having the formats in a personalized column, because in detail of the book you can see the different formats of the same book.

08-07-2021, 05:09 PM	#1
Calibre26 Enthusiast Posts: 44 Karma: 31526 Join Date: Nov 2019 Device: Kindle 8th Edition	Column showing book formats The only threads I found were from 10 years ago. And there seems to be more options now. In Lookup name I entered Format. In column heading I entered Formats. In column type I chose column built from other columns (although there is an option with behaves like tags). I have no idea what else to fill in. Have I done the right thing to get a column showing all my books and their formats?

08-08-2021, 01:05 PM	#4
kenmac999 Member Posts: 22 Karma: 10 Join Date: Sep 2013 Location: Oklahoma Device: Devices: Motorola G Power 5G, ASUS C436F Chromebook, Kindle Fire 7" Ap	Are you wanting a column that displays all the formats with another field(s) or a custom column that shows how many (number) different formats of a particular book you have? I created 3 custom columns that I call "Formats", "Location" and "All Formats"(column heading) "Formats" (created using quick create option) Code: Lookup name: formats Column heading: Formats Column type: Column built from other columns Description: eBook Formats available Template: {formats} "Location" Code: Lookup name: locate Column heading: Location Column type: Text, column shown in the Tag browser Description: Shelf location of physical books or whether it is an Audiobook Template: {formats} "All Formats" Code: Lookup name: mod_format Column heading: All Formats Column type: Column built from other columns Description: Combines informat from Formats and Location columns Template: {:'approximate_formats()'} {#locate} I only display the "All Formats" column. I can quickly glance at the All Formats column to see what format my ebooks are in (AZW(3), EPUB, MOBI, PDB, PDF) or if I also have an audiobook or physical edition also. Since I started collecting books over 40 years ago I am trying to slowly replace my physical books with audio and ebooks. I love reading physical books but I also enjoy the convenience of carrying ebooks and audiobooks on my phone. Some weeks I will be reading 3 different books depending on where/what I am doing.

08-08-2021, 04:23 PM	#6
dunhill Guru Posts: 893 Karma: 810834 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite	This is due to having the formats in a personalized column, because in detail of the book you can see the different formats of the same book. Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre showing multiple formats	goobus	Library Management	8	06-13-2013 03:22 PM
Column for see formats?	Ansem_93	Library Management	15	03-25-2013 09:53 PM
Formats showing incorrectly	sikm	Library Management	3	02-15-2013 02:24 AM
Not all formats showing using the server	Chauncey	Calibre	8	12-08-2011 08:34 PM
formats column	Philosopher	Calibre	17	01-20-2011 06:23 PM

08-07-2021, 06:11 PM	#2
BetterRed null operator (he/him) Posts: 21,724 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	BR

08-07-2021, 06:43 PM	#3
Calibre26 Enthusiast Posts: 44 Karma: 31526 Join Date: Nov 2019 Device: Kindle 8th Edition	BetterRed, that's fantastic, thank you. Didn't expect it to be so straightforward. Great name btw.

08-08-2021, 02:12 PM	#5
Calibre26 Enthusiast Posts: 44 Karma: 31526 Join Date: Nov 2019 Device: Kindle 8th Edition	Kenmac999 it was just a column showing each book's format at a glance. But thanks for the ideas.

Advert

Advert