Yes/No column built from other columns

[barlowrm]

Dear all,

I am experimenting with columns built from other columns.

I can easily create a text column, but I was wondering if one could also use templates to control a Yes/No column.

I can of course build a text column whose contents are "Yes" and "No", but I find the icon display in the Yes/No column more effective than text.

Thanks for your help,

Andrea.

[BetterRed]

@barlowrm - Have a look at Preferences->Look and Feel->Column icon (rightmost tab).

I would use Icon with no text, on an integer column, and then make use of the template logic that yields 'Yes' or 'No', in an Advanced Rule template that yields 'green tick.png' or 'red cross.png'. The value of the integer column is irrelevant, it's just a hook on which to hang an icon (or more if you use "Composed (i.e. multiple) icons with no text)

Then I would remove the composite column.

You must supply the icon images (a 128px square PNG is recommended, with transparent edges is best), I keep mine in a myIcons folder in the calibre config directory. I can usually find something suitable here ==>> Browse Icon Packs - FindIcons.com

Waiting for Midnight to arrive at Greenwich Observatory is a bit like Waiting for Godot

BR

[chaley]

Originally Posted by barlowrm

Dear all,

I am experimenting with columns built from other columns.

I can easily create a text column, but I was wondering if one could also use templates to control a Yes/No column.

I can of course build a text column whose contents are "Yes" and "No", but I find the icon display in the Yes/No column more effective than text.

Thanks for your help,

Andrea.

Just check the "Show Checkmarks" box in the column definition. This box is available if the column is not "behaves like tags". If the result of the template is recognizable as boolean (Yes, No, true, false, etc) then an icon is displayed instead of the text.

[barlowrm]

Hi @BetterRed,

and thanks *again* for your reply. This works greatly, except I don't seem to be able to sort on an icon column. It works if in addition to the icon I attach some text to the column using a template. Then the icons are just ignored in the sorting.

I must admit I am not even sure what the "correct" behavior here would be. I guess sorting on icon filename would already be better than no sorting at all (at least it would group entries with identical icons). Do you know if there is a way to obtain this?

Thanks for your help,

Andrea.

[barlowrm]

Originally Posted by chaley

Just check the "Show Checkmarks" box in the column definition. This box is available if the column is not "behaves like tags". If the result of the template is recognizable as boolean (Yes, No, true, false, etc) then an icon is displayed instead of the text.

Hi Chaley,

thanks for your reply. This gives me indeed both the Yes/No icons and the columns sort.

Cheers,

Andrea.

[BetterRed]

Originally Posted by chaley

Just check the "Show Checkmarks" box in the column definition. This box is available if the column is not "behaves like tags". If the result of the template is recognizable as boolean (Yes, No, true, false, etc) then an icon is displayed instead of the text.

@chaley - I never knew that, I've always read it as being 'show checkboxes in the Tag Browser' (for multiple column searching) When I couldn't see them I shrugged and moved on; I don't use the Tag Browser much.

@barlowrm - sorry for the garden path, the lesson is: if you want to know what a field does look at the tool tip (I know that now, but I didn't when I started):-

Show checkmarks
Show check marks in the GUI. Values of 'yes', 'checked', and 'true' will show a green check. Values of 'no', 'unchecked', and 'false' will show a red X. Everything else will show nothing.

Can't get clearer than that.

BR