Automatically tag based on column info?

[Iocane]

The short question is basically what it says in the title. Can Calibre automatically tag, or edit a custom column to a given listing based on information from another column. Not simply copying, which seems to be what "Column built from other columns" is for.

Longer explaination: I use the page count plug ins and I would like to split my books roughly by size. I.e. 10 pages or less, Micro, 10-25 pages, Tiny and so on. I'd like to have a Story Size column that set itself automatically to the size of the story based on the number of pages. So if the Page count column is updated to 17 pages, the Story Size column automatically sets itself to Tiny.

Is this at all possible? If so, is it something one of you kindly souls would be willing to talk me through?

(I hope this is the right forum, if not, my apologies!)

[chaley]

You can do this with columns built from other columns. You would use a General Program Mode template that returns a different value based on the number of pages. You would use "first_non_empty" and "cmp" to produce the correct values.

I am not currently in a position to write the template for you. Perhaps someone else can help out, should you need it.

[Iocane]

Thanks! I'll have a look at the link when I'm not quite so sleep deprived

[Man Eating Duck]

Originally Posted by chaley

I am not currently in a position to write the template for you. Perhaps someone else can help out, should you need it.

Here:

{#pages:'first_non_empty(
 cmp($, 10, 'Tiny', '', '')
,cmp($, 25, 'Short', '', '')
,cmp($, 100, 'Medium', '', '')
,cmp($, 300, 'Long', 'Brick', 'Brick')
)'}

Just paste this into the template field in Columns built from other colums (line breaks are removed, but makes changes easier prior to pasting).
It works by successively comparing number of pages and selecting that value if the number is lower. I suppose you figure out how to change it to suit your preferences

You can copy/paste the second to last cmp line if you want more values.