[chaley]

Originally Posted by BetterRed

I have the following saved search to identify 'books' that I don't have in some form or another.

formats:"false" and not comments:"Book is Here"

The "Book is Here" in Comments is a label I use on URI links to something external to the library

In addition to (or maybe instead of) the saved search I would like to have a column in the spreadsheet that would show something like , otherwise nothing would show

I've tried a couple of things but I failed to get a result - maybe someone can teach an old dog a new trick

TIA - BR

This advanced rule adds a sad face to the title if the conditions you describe above are true.

program:
	test(
		and(
			not(approximate_formats()), 
			contains(field('comments'), "Book is Here", '','y')), 
		'emotes-face-sad-icon.png', 
		'')

Here is a screen capture of the result. The first "Inconnu(e)" has the comment

foo
Book is Here
bar

Here is a screen capture of the advanced rule editor.


And for completeness, here is a link to the sad face icon I used.
http://www.iconarchive.com/show/oxyg...-sad-icon.html