Thread: Yes/No column with 2 choice only
View Single Post
Old 10-11-2016, 06:28 AM   #7
chaley
Grand Sorcerer
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: 12,463
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by nqk View Post
Maybe you create another custom column to read the info from the read column. If "yes" then returns "Yes", else returns "No". Now you have a column with only Yes/No for the Companion.

But I have no idea how to formulate such template. I'm sure @chaley can help. He did give me two templates. .

I myself can only think of {#readstatus:contains(Yes, Yes, No)}
This idea could work in one of two ways.

Make a composite column (column built from other columns) with the template, replacing #mybool2 with the lookup name of your Yes/No column:
  1. Code:
    {#mybool2}
    This column converts the 2-state boolean to 3-state so you can easily see/search in calibre for which values need to be updated to "No".
  2. Code:
    {#mybool2:ifempty(No)}
    This column contains only the values Yes and No. There are no empty values. You would put this column into CC's grouping drawer, replacing the Yes/No column you already have there.
chaley is offline   Reply With Quote