yes/no column for comments box filled?

hobnail · 02-16-2022, 06:05 PM

How can I make a column that has a check mark if the metadata's Comments box is filled in, the big box on the right in the metadata editor?

ownedbycats · 02-16-2022, 06:11 PM

Code:

program: if $comments then 'yes' fi

If you also want x's:

Code:

program: if $comments then 'yes' else 'no' fi

Column built from other columns, show checkmarks, set sort to yes/no.

hobnail · 02-16-2022, 10:54 PM

Thanks, I'll give that a shot. ...

Duh, I didn't see that I already had one set up; I swear I looked. The code it uses is

Code:

program:test(field('comments'), 'Yes', '')

I just changed it to use a No instead of empty quotes for the last one.

02-16-2022, 06:05 PM	#1
hobnail Running with scissors Posts: 1,598 Karma: 14328510 Join Date: Nov 2019 Device: none	yes/no column for comments box filled? How can I make a column that has a check mark if the metadata's Comments box is filled in, the big box on the right in the metadata editor?

02-16-2022, 06:11 PM	#2
ownedbycats Custom User Title Posts: 11,410 Karma: 80995913 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Code: program: if $comments then 'yes' fi If you also want x's: Code: program: if $comments then 'yes' else 'no' fi Column built from other columns, show checkmarks, set sort to yes/no. Last edited by ownedbycats; 02-16-2022 at 07:14 PM.

02-16-2022, 10:54 PM	#3
hobnail Running with scissors Posts: 1,598 Karma: 14328510 Join Date: Nov 2019 Device: none	Thanks, I'll give that a shot. ... Duh, I didn't see that I already had one set up; I swear I looked. The code it uses is Code: program:test(field('comments'), 'Yes', '') I just changed it to use a No instead of empty quotes for the last one.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show comments in column	nhgbslik	Library Management	3	09-18-2019 05:52 PM
Can I have a custom column filled when adding books?	LadyKate	Library Management	1	10-01-2016 11:58 PM
Comments column	Tanjamuse	Calibre	11	04-17-2016 06:18 AM
using re() and shorten() for custom comments column?	rebl	Library Management	8	09-07-2014 05:58 AM
Text Colour In Comments Box 7.40	JayLaFunk	Calibre	9	01-15-2011 04:28 PM

Advert