|  01-07-2011, 05:35 AM | #1 | 
| Connoisseur  Posts: 77 Karma: 12 Join Date: Jun 2010 Device: Kindle |  formats column 
			
			Someone was kind enough to show me how to create an isbn column. How can I create a column which displays the formats? Thanks. | 
|   |   | 
|  01-07-2011, 05:46 AM | #2 | 
| Grand Sorcerer            Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2 | 
			
			Just as you did for isbn, create a custom column 'built from other columns'. The template is {formats}
		 | 
|   |   | 
| Advert | |
|  | 
|  01-07-2011, 05:23 PM | #3 | 
| Junior Member  Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle | 
				
				ok lets see if you can help me
			 
			
			i am wanting to get the column to  show only one format at a time aka i want it to show a yes or no if it has mobi  and another to show if it has epub  and so on ... so you think that is possible and if it's already been covered im sorry ... just trying to find a way to keep it up to date automatically i know i can make a column that says mobi with yes/no  and so on for each format and edit by hand  you get the idea what i am wanting to do hope you can help
		 Last edited by iceman31ad; 01-07-2011 at 05:25 PM. Reason: been up for 2 days with a sick little girl | 
|   |   | 
|  01-07-2011, 05:37 PM | #4 | 
| Wizard            Posts: 2,013 Karma: 251649 Join Date: Apr 2010 Location: Tempe, AZ, USA, Earth Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home) | 
			
			If I understand you correctly, what you are proposing may be unnecessarily complicated. Just make a format column the way chaley suggested. To view one format only, open the Tag browser (the button with the little luggage tag on it), click on the Format bitton, then click on the one you want to display. That will display only the books with that format. Of course, I may have totally misunderstood you.  I hope your little girl is feeling better. | 
|   |   | 
|  01-07-2011, 06:12 PM | #5 | |
| Well trained by Cats            Posts: 31,241 Karma: 61360164 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A | Quote: 
  with all that, when you can use the luggage tag  (or search tool) format section? formats:mobi formats:epub then all you see is:   | |
|   |   | 
| Advert | |
|  | 
|  01-07-2011, 07:01 PM | #6 | 
| Junior Member  Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle | 
				
				i have my reasons
			 
			
			i have received over 2000 ebooks in all sorts of formats some in multiple formats and some where the meta data is there but nothing else and most of these are for my wife for use on her kindle. and i want to be able to sort it out example i want to all  epub books and see  if it has  a mobi format or not then so a batch conversion  and know if the conversion took  any other way  and  you have to  go one by one. or worse yet print a page and search does this make any sense now edit thought how can you make a column query wither a format is there i know you have the tab but can you get it to just display the info in the column with out hand editing aka a column that asks is mobi there yes or no i was thinking the code to make it work would be {format}*(mobi=true)* but i all i got was a listing with mobi=true after it been up with a sick little girl for 2 days so plaese if its not posible just say so if its complicated give it a try its beyond me i know but if you are going to say its too hard and tell me to do it the way i have been doing it please don't bother Last edited by iceman31ad; 01-07-2011 at 07:13 PM. | 
|   |   | 
|  01-07-2011, 07:39 PM | #7 | 
| Calibre Plugins Developer            Posts: 4,735 Karma: 2197770 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis | 
			
			That was a long sentence   What the others are suggesting is that perhaps your best bet is just to use the search engine rather than using custom columns as it should give the same effect. For instance to find all the books that have EPUB but do not have MOBI, type this into the search box: format:epub and not format:mobi | 
|   |   | 
|  01-07-2011, 08:00 PM | #8 | |
| Well trained by Cats            Posts: 31,241 Karma: 61360164 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A | Quote: 
 Extremely useful with more complex searches  formats:true and not formats:epub <-show me books that need conversion to epub but hide empty books | |
|   |   | 
|  01-07-2011, 08:18 PM | #9 | 
| Junior Member  Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle | 
			
			ok   thats not how i wanted to do it  but it does what i want to do  with out having to check each one individually thank you both  and yes i did try reading the instruction manual but that thing needs a true toc | 
|   |   | 
|  01-07-2011, 08:45 PM | #10 | |
| Well trained by Cats            Posts: 31,241 Karma: 61360164 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A | Quote: 
  With easy to find "Desired Results", step by step instructions  I want to do for... Kindle User: Sony user: Drop box: MAC: Ubuntu: Win7: XP:  I don't know about you, but screen width has become precious (and I only added 3 small columns and hid a few) on my widescreen monitor. So using a filter/saved search to do something that saves screen width, gets my   | |
|   |   | 
|  01-07-2011, 09:52 PM | #11 | 
| Junior Member  Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle | 
			
			yea that sounds better
		 | 
|   |   | 
|  01-08-2011, 04:17 AM | #12 | 
| Grand Sorcerer            Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2 | 
			
			@iceman31ad: you can do what you want. Showing you will need to wait until tomorrow, as today is fully booked. If you want to give it a try, use something like {formats:contains(epub,Yes,No)} | 
|   |   | 
|  01-14-2011, 03:09 PM | #13 | 
| Junior Member  Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle | 
			
			well it looks like that is half way there i tried tweaking it but i keep getting errors like it always says no
		 | 
|   |   | 
|  01-14-2011, 03:21 PM | #14 | 
| Grand Sorcerer            Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2 | 
			
			Use {formats:contains(EPUB,Yes,No)}  The test is case-sensitive | 
|   |   | 
|  01-14-2011, 10:12 PM | #15 | 
| Junior Member  Posts: 8 Karma: 10 Join Date: Dec 2010 Device: kindle | 
			
			ok i am an idiot i didnt think about case at all
		 | 
|   |   | 
|  | 
| Thread Tools | Search this Thread | 
| 
 | 
|  Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
| 2 column PDF book to 1 column possible? | SeaBookGuy | Calibre | 19 | 07-01-2013 02:30 AM | 
| Q: multi-column PDF to single column mobi format converstion | auburn1975 | Calibre | 7 | 01-28-2012 06:11 PM | 
| PDF with two column | Gho57 | Amazon Kindle | 10 | 05-16-2011 01:01 AM | 
| Convert Epub and Msreader formats to Kindle formats | bruc79 | Calibre | 17 | 06-22-2010 04:50 AM | 
| pdf to lrf with 2 column and 1 column pages in same file | danielwille | Sony Reader | 3 | 11-12-2008 10:57 AM |