How do I create a custom 'price' column?

bumpofbumps · 09-16-2020, 02:13 AM

I'm not entirely new to calibre. Been using it for well over a year. However, I've just gotten into creating custom columns. I've heard about using calibre to organize books that you want and that you can make a column centered around price and such. I'm just not entirely sure on how to make it happen. I know that I need to set the new column to be integer, but then I'm confused beyond all belief and cannot find a way so then I can have it include decimals (because... you know... prices are generally in decimals...). I want it set to USD so then I can track how much it is. This is especially important for helping me track of how much new books I want to get costs.

davidfor · 09-16-2020, 02:35 AM

Unless you are storing the price as cents, you probably don't want to use integers. You probably want to use "Floating point numbers". That will let you enter the number as dollars with cents. And, to answer the unasked question, you can set the "Format as numbers" to:

Code:

${:,.2f}

That will show it with a leading $ sign and always with two decimals.

chaley · 09-16-2020, 02:38 AM

Set the column type to "Floating point numbers" Currency is irrelevant because calibre doesn't know that the number represents money.

However, if you want to see the number formatted with a $ symbol, when you create the column use the format

Code:

$ {0:,.2f}

bumpofbumps · 09-16-2020, 11:40 PM

Thank you so much! You've been very helpful.

09-16-2020, 02:13 AM	#1
bumpofbumps Collector Posts: 2 Karma: 10 Join Date: Sep 2020 Device: none	How do I create a custom 'price' column? I'm not entirely new to calibre. Been using it for well over a year. However, I've just gotten into creating custom columns. I've heard about using calibre to organize books that you want and that you can make a column centered around price and such. I'm just not entirely sure on how to make it happen. I know that I need to set the new column to be integer, but then I'm confused beyond all belief and cannot find a way so then I can have it include decimals (because... you know... prices are generally in decimals...). I want it set to USD so then I can track how much it is. This is especially important for helping me track of how much new books I want to get costs.

09-16-2020, 02:35 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Unless you are storing the price as cents, you probably don't want to use integers. You probably want to use "Floating point numbers". That will let you enter the number as dollars with cents. And, to answer the unasked question, you can set the "Format as numbers" to: Code: ${:,.2f} That will show it with a leading $ sign and always with two decimals.

09-16-2020, 02:38 AM	#3
chaley Grand Sorcerer Posts: 12,395 Karma: 8012652 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Set the column type to "Floating point numbers" Currency is irrelevant because calibre doesn't know that the number represents money. However, if you want to see the number formatted with a $ symbol, when you create the column use the format Code: $ {0:,.2f}

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a custom column to enter URLs ?	Crusher	Library Management	5	12-03-2018 04:15 PM
How do I create a icons only custom column?	pleiadesc	Library Management	3	09-24-2017 08:58 PM
Custom Column: Price	Nyssa	Library Management	31	07-14-2017 01:49 AM
Looking for how to create a custom column based on a tag	kaufman	Library Management	10	02-12-2014 11:15 AM
create custom format column	blaubach	Calibre	12	09-17-2010 03:22 PM

09-16-2020, 11:40 PM	#4
bumpofbumps Collector Posts: 2 Karma: 10 Join Date: Sep 2020 Device: none	Thank you so much! You've been very helpful.

Advert