View Single Post
Old 03-23-2013, 07:29 AM   #1
Philantrop
Addict
Philantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beautyPhilantrop does all things with Zen-like beauty
 
Philantrop's Avatar
 
Posts: 296
Karma: 32153
Join Date: Dec 2008
Device: Kindles (e-ink)
Custom yes/no column built from long text column

I have a custom column "foo" of type "Long text, like comments, not shown in the tag browser" which either contains nothing at all or some text.

I'd like to have a simple "Yes/No" column "bar" that, in the library view, shows if "foo" contains anything.

So I added said "Yes/No" column of type "Column built from other columns" and used this template:

program: test(select(field('#annotations'),'.*'),'Yes ','No')

Unfortunately, this function always returns "No". Even when replacing the '.*' with 'e' (because I had prepared "foo"'s content to contain it), it still returned "No".

I've experimented with just using test() but whatever I tried, it simply either returned "Yes" or "No" for *all* entries, regardless of "foo"'s actual content.

Can someone please lend me a hand here? :)
Philantrop is offline   Reply With Quote