Possible other than yes/no?

MerlinMama · 02-17-2016, 08:39 AM

I'm reaching a bit here, but I find myself in need of (well, more wishing for) a yes/no-type column, using three values, that uses choices other than yes/no (and empty). Is there a way to do this that I've missed?

I would even settle for changing the images, and adding one for the blank value. I also would prefer the same means of filling it — or even better, check boxes — but I won't push my luck more than I am at the moment.

pdurrant · 02-17-2016, 10:13 AM

So you want a four-valued column? undefined, yes, no and maybe?

Divingduck · 02-17-2016, 10:17 AM

We called it 30 years ago a "sometimes maybe"-circuit

MerlinMama · 02-17-2016, 11:06 AM

Quote:

Originally Posted by pdurrant

So you want a four-valued column? undefined, yes, no and maybe?

Not at all. I want the behavior, or structure, of the three-value, yes/no column, but with labels OTHER than yes/no.

For example, one of the (many) ways I might use it if available:

I add a book, I would want it indicating No (for my purposes, there would be NO undefined -- if there has to be, then I suppose yes it would be a four-value column, but that's not what I'm looking for). I guess it could also stay as undefined, I wouldn't mind that so much if I can customize the other two...
If I went through the metadata, but have not edited the file otherwise, I would want it indicating some variation of Partial (Part, MD, whatever I choose).
After I go through and then edit the epub file to how I like my files, I would want it indicating Yes (or Full, or Edit, or whatever final 'wording' I pick).

If I could not change the labels (yes/no) if I could customize the image for each of the 3 options, since that is all that shows in the columns:

current "No" image (red circle with 'x' in middle) in undefined,
orange circle with straight line in middle for no, and
green circle with check for yes,

that would certainly work. I simply like the structure of the yes/no setup, as opposed to the other options available for what I would like.

kovidgoyal · 02-17-2016, 11:10 AM

Use the enumerated column type

MerlinMama · 02-17-2016, 11:12 AM

Quote:

Originally Posted by kovidgoyal

Use the enumerated column type

I haven't seen an enumerated column type...

kovidgoyal · 02-17-2016, 11:18 AM

"Text, but with a fixed set of permitted values"

MerlinMama · 02-17-2016, 11:28 AM

Thank you! I knew I had to be overlooking something simple. I can put my values AND add the colors I want. Perfect!

02-17-2016, 08:39 AM	#1
MerlinMama Evangelist Posts: 498 Karma: 32554 Join Date: May 2014 Location: Canada Device: Kobo Sage	Possible other than yes/no? I'm reaching a bit here, but I find myself in need of (well, more wishing for) a yes/no-type column, using three values, that uses choices other than yes/no (and empty). Is there a way to do this that I've missed? I would even settle for changing the images, and adding one for the blank value. I also would prefer the same means of filling it — or even better, check boxes — but I won't push my luck more than I am at the moment.

02-17-2016, 10:13 AM	#2
pdurrant The Grand Mouse 高貴的老鼠 Posts: 73,986 Karma: 315160596 Join Date: Jul 2007 Location: Norfolk, England Device: Kindle Oasis	So you want a four-valued column? undefined, yes, no and maybe?

02-17-2016, 10:17 AM	#3
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	We called it 30 years ago a "sometimes maybe"-circuit

02-17-2016, 11:10 AM	#5
kovidgoyal creator of calibre Posts: 45,369 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Use the enumerated column type

02-17-2016, 11:18 AM	#7
kovidgoyal creator of calibre Posts: 45,369 Karma: 27230406 Join Date: Oct 2006 Location: Mumbai, India Device: Various	"Text, but with a fixed set of permitted values"

02-17-2016, 11:28 AM	#8
MerlinMama Evangelist Posts: 498 Karma: 32554 Join Date: May 2014 Location: Canada Device: Kobo Sage	Thank you! I knew I had to be overlooking something simple. I can put my values AND add the colors I want. Perfect!