| 
			
			 | 
		#1 | 
| 
			
			
			
			 Member 
			
			![]() Posts: 22 
				Karma: 10 
				Join Date: Jul 2017 
				
				
				
				Device: none 
				
				
				 | 
	
	
	
		
		
			
			 
				
				Which custom columns do you use?
			 
			
			
			Hello, 
		
	
		
		
		
		
		
		
		
		
		
		
	
	I use Calibre to manage my home library of paper books. I have now been thinking which one columns would be useful to describe a book well. So far I only use price, location and page number. What other columns do you use?  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#2 | 
| 
			
			
			
			 Wizard 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,688 
				Karma: 9500498 
				Join Date: Sep 2021 
				Location: Australia 
				
				
				Device: Kobo Libra 2 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			I also use Calibre to manage my paper library with stub files, as well as my ebooks. 
		
	
		
		
			This is the metadata I track. I have been thinking of adding a word count for the novel, but haven't got around to doing that yet...  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#3 | 
| 
			
			
			
			 Resident Curmudgeon 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 80,782 
				Karma: 150249619 
				Join Date: Nov 2006 
				Location: Roslindale, Massachusetts 
				
				
				Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			A rather useful column is ayes/no column for Read.
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#4 | 
| 
			
			
			
			 Well trained by Cats 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 31,267 
				Karma: 61916422 
				Join Date: Aug 2009 
				Location: The Central Coast of California 
				
				
				Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			I prefer a Date for read  ( also use Year 2000 to mark abandoned) 
		
	
		
		
		
		
		
		
		
		
		
		
	
	I also have columns for the Count Pages PI 2 others I have T/F Verified (EPUB), where it passes the Debug part of the Editor and a date that I do (clean/tweak to my style) Edits. Blank is not done. BTW I use tri-state T/F. T pass, F failed (not fixed) blank NOT Verified IMHO Lean and Mean. don't make a column for something a saved search can show. Blank can have a meaning (there is a place in the Add your own columns form for notes. use it  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#5 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				Karma: 79528341 
				Join Date: Oct 2018 
				Location: Canada 
				
				
				Device: Kobo Libra H2O, formerly Aura HD 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			Here's how it looks for me. 
		
	
		
		
			1. I use a 0-byte 'paperbook' file to filter my physical books. 2. I use a custom 'ratings' column in order to use a 10-point scale instead of the default 5-point one. 3. I use an integer #percentread and a template that converts them into a reading status. But it's easier to just use a boolean like JSWolf suggested. 4. Knowing when a book was last read is useful sometimes. 5. Chapter, page, and wordcounts, though for obvious reason I skip wordcounts for paper books. 6. Book type: I have Fiction, Nonfiction, Fanfiction, Comics, Magazines & Periodicals, and Documentation & Manuals. This mostly is for sorting into virtual libraries. 7. Some Kobo-specific columns. This is for eBooks on my device. 8. Filedate and filename are also for eBooks -- I get them automatically with a plugin. I also have a bunch of fanfic-specific columns and one specific to documentation/manuals, but I hid them for the screenshot. Last edited by ownedbycats; 03-16-2022 at 09:36 AM.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#6 | 
| 
			
			
			
			 Member 
			
			![]() Posts: 22 
				Karma: 10 
				Join Date: Jul 2017 
				
				
				
				Device: none 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			@Karellen: Movie sounds like a very interesting column, I like it. 
		
	
		
		
		
		
		
		
		
		
		
		
	
	@JSWolf: Oh yes, I didn't even think of that - very useful of course @theducks: On a date for read I've never really found anything, but maybe I'll include it anyway. @ownedbycats: I'll definitely record the number of chapters, I'll have to take a closer look at the rest. @All: Thanks a lot to you guys, I can definitely do quite a bit with this. But I am still open to further ideas. That I have not come to the read column is almost embarrassing.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#7 | 
| 
			
			
			
			 Grand Sorcerer 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 13,993 
				Karma: 243829945 
				Join Date: Jan 2014 
				Location: Estonia 
				
				
				Device: Kobo Sage & Libra 2 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			Page count, Reading status, Device column (which devices a book is on, if any), From (where I acquired the book), Price. 
		
	
		
		
		
		
		
		
		
		
		
		
	
	I also have a few composite columns to use for catalogs and a custom series column for numbering the many omnibus editions in my library (I don't want to split them). I don't have any columns for editing status, as I don't need them. If a book has no page count, it's not been edited yet and that's easy to see at a glance. I only use a custom page count and run it after I've finished editing metadata and formatting.  | 
| 
		
 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#8 | |
| 
			
			
			
			 Wizard 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,292 
				Karma: 1428263 
				Join Date: Dec 2016 
				Location: Goiânia - Brazil 
				
				
				Device: iPad, Kindle Paperwhite, Kindle Oasis 
				
				
				 | 
	
	
	
		
		
		
		
		 Quote: 
	
 How did you change from 5 to 10-point rating scale?  | 
|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#9 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				Karma: 79528341 
				Join Date: Oct 2018 
				Location: Canada 
				
				
				Device: Kobo Libra H2O, formerly Aura HD 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			You can't do it with the default column. So I created a custom rating-type column with "allow half stars" enabled.  
		
	
		
		
			Then I used search & replace to copy over existing ratings and swapped the columns around in the book list. Last edited by ownedbycats; 03-16-2022 at 11:13 AM.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#10 | |
| 
			
			
			
			 Wizard 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,292 
				Karma: 1428263 
				Join Date: Dec 2016 
				Location: Goiânia - Brazil 
				
				
				Device: iPad, Kindle Paperwhite, Kindle Oasis 
				
				
				 | 
	
	
	
		
		
		
		
		 Quote: 
	
 I thought you were saying that the ratings would vary from 0 to 10.  | 
|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#11 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				Karma: 79528341 
				Join Date: Oct 2018 
				Location: Canada 
				
				
				Device: Kobo Libra H2O, formerly Aura HD 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			Yes. Half-stars give you a 10-point scale.
		 
		
	
		
		
			 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#12 | 
| 
			
			
			
			 Wizard 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,292 
				Karma: 1428263 
				Join Date: Dec 2016 
				Location: Goiânia - Brazil 
				
				
				Device: iPad, Kindle Paperwhite, Kindle Oasis 
				
				
				 | 
	
	|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#13 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				Karma: 79528341 
				Join Date: Oct 2018 
				Location: Canada 
				
				
				Device: Kobo Libra H2O, formerly Aura HD 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			It displays as 1-5 stars, but the database stores it as whole numbers.
		 
		
	
		
		
		
		
		
		
		
		
		
		
		
			Last edited by ownedbycats; 03-16-2022 at 03:34 PM.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#14 | 
| 
			
			
			
			 Resident Curmudgeon 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 80,782 
				Karma: 150249619 
				Join Date: Nov 2006 
				Location: Roslindale, Massachusetts 
				
				
				Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3 
				
				
				 | 
	
	|
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#15 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				Karma: 79528341 
				Join Date: Oct 2018 
				Location: Canada 
				
				
				Device: Kobo Libra H2O, formerly Aura HD 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			I assumed compatibility reasons, seeing as you can toggle half-stars off and on at will. There's some oddities about how it's stored in the database, too.
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
![]()  | 
            
        
            
            
  | 
    
			 
			Similar Threads
		 | 
	||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
| Ratings Custom Columns Created From other Columns | Tanjamuse | Library Management | 4 | 09-28-2020 01:57 AM | 
| Custom sort order for custom columns? | matjojo | Library Management | 5 | 11-24-2019 12:30 PM | 
| Help Needed for Custom Columns Created From other Columns | Tanjamuse | Library Management | 5 | 09-02-2018 07:19 PM | 
| Custom columns | ChipAHoy | Library Management | 1 | 02-23-2018 03:50 AM | 
| Custom Columns - How are you using yours? | nynaevelan | Library Management | 19 | 04-18-2011 01:42 AM |