Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 09-16-2020, 02:13 AM   #1
bumpofbumps
Collector
bumpofbumps began at the beginning.
 
bumpofbumps's Avatar
 
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.
bumpofbumps is offline   Reply With Quote
Old 09-16-2020, 02:35 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 20,241
Karma: 33549158
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.
davidfor is offline   Reply With Quote
Old 09-16-2020, 02:38 AM   #3
chaley
Grumpy old git
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 9,386
Karma: 3007492
Join Date: Jan 2010
Location: UK
Device: Reader
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}
chaley is offline   Reply With Quote
Old 09-16-2020, 11:40 PM   #4
bumpofbumps
Collector
bumpofbumps began at the beginning.
 
bumpofbumps's Avatar
 
Posts: 2
Karma: 10
Join Date: Sep 2020
Device: none
Thank you so much! You've been very helpful.
bumpofbumps is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 06:05 PM.


MobileRead.com is a privately owned, operated and funded community.