Custom Column: Price

[theducks]

How about using a column like identifiers? Unfortunately, there does not seem to be a Custom Column like identifiers, but that does not stop you from using it.
The only issue, is redownloading metadata might stomp on your (slightly) custom type

Yen:570
Free:0
AuD:5.70
USD:3.99

The thing with identifiers is it really is 2 parts. The type:value

They are also selectable in the Tag Browser

[chaley]

Originally Posted by Inukami

@chaley, thanks for this information. It looks very useful and I think I will use the colouring for free books.

TBH I am not sure what you want to do. More comments below

I'm also assuming you could get Calibre to also do the following with composite columns? If price is value or 0.00, have another column say either BOUGHT or FREE using logic...

Yes, you can do this.

On the other hand, I do have two currencies (Australian dollar & Japanese Yen). Would it be possible to choose which currency to choose from in one column, or would you need to make another column?

If you had to have another column #price2, could you set that to be active if the #price1 is blank?

• Australian Dollars $5.00
• Japanese Yen ¥650
• Free Book $0.00

Here is where I am confused. Is a book priced in more than one currency? Is the problem getting the correct currency symbol to display? To use different colors for different currencies? And more complicated: how are they supposed to sort? By currency then value? By value, and if so the raw value or the some converted value? For example, JPY 100 is smaller than AUD 10 but 100 is larger than 10. Or is sorting not needed? What exactly are you trying to do?

Theduck's idea of using something like identifiers can work. The template language has functions for manipulating identifer-like items. For example, and assuming a book has only one price/currency pair, you can have a column that contains the price as AUD:10. You could then have two composite columns, one that contains the bare price for sorting (ignoring currency) and another to contain the value however you want it formatted for display. You could do something similar with 2 base columns: one float for the number and one enumerated text for the currency; and a composite column to put them together for display.