Help with Icon Rule

[Tanjamuse]

Hi everyone.

I need some help with an advanced rule in the icons section.

I have this rule already, but I need to add another column to it.

program:
	test(
		or(
			contains(field('#ships'), "Angela Montenegro/Jack Hodgins", 'y', ''),
			contains(field('#ships'), "Temperance Brennan/Seeley Booth", 'y', ''),

		),
		'ships (crime).png',
		''
)

I would like to add another condition which is: If my reading list column is "Interesting".

Is that possible?

[chaley]

You can have as many "contains" lines as you want in the "or". Assuming you want the same icon if #readinglist contains interesting then just add a third "contains" to the "or".

If you want different a different icon for "interesting" then you should use "first_non_empty" instead of "or" and have the "contains" return the name of the icon instead of "y". Something like

program:
	first_non_empty(
			contains(field('#ships'), "Angela Montenegro/Jack Hodgins", 'ships (crime).png', ''),
			contains(field('#ships'), "Temperance Brennan/Seeley Booth", 'ships (crime).png', ''),
			contains(field('#readinglist'), "interesting", 'someicon.png', '')
	)

[Tanjamuse]

Maybe I've not expressed myself correctly.

I need the rule to say if any of the following relationships AND on the reading list.

not

if any of the following relationships OR on the reading list.

[chaley]

Something like

program:
	test(
		and(
			contains(field('#readinglist'), 'interesting', 'y', ''),
			or(
				contains(field('#ships'), "Angela Montenegro/Jack Hodgins", 'y', ''),
				contains(field('#ships'), "Temperance Brennan/Seeley Booth", 'y', '')
			),
		),
		'ships (crime).png',
		''
)

If #readinglist is a "like tags" column then you might want to "str_in_list" instead of "contains".

[Tanjamuse]

The Reading List is a Text, but with a fixed set of permitted values.

[Tanjamuse]

I've tried the newest rule and the icon is still added to all the books on the "Interesting" Reading List, not just those with the relationship tags mentioned.

[chaley]

It works for me. I don't know why it doesn't work for you.

The first screen image shows what I tested. It checks an enum column for "def". If that exists then it checks my Genre column for various things, only one of which is ever there (comics). I see the icon only on books that match, as you can see in the screen capture. The text shown with the icon is a version of the template that returns the name of the PNG you are using.

[Tanjamuse]

The reading list column is a Text, but with a fixed set of permitted values and my relationship column has a checkmark in contains names and it's a normal tag-column.

Does that make a difference?

[Terisa de morgan]

Originally Posted by Tanjamuse

The reading list column is a Text, but with a fixed set of permitted values and my relationship column has a checkmark in contains names and it's a normal tag-column.

Does that make a difference?

It shouldn't, the rule looks right. Could you get a screenshot of the rule... and the result in the library, where the fields are shown? Perhaps it can make clear the problem.

[chaley]

Originally Posted by Tanjamuse

The reading list column is a Text, but with a fixed set of permitted values and my relationship column has a checkmark in contains names and it's a normal tag-column.

Does that make a difference?

In my example, #enum is a column like yours, with a fixed set of values. The #genre column is like yours, text, like tags. It does not have the "contains names" box checked, but that shouldn't make a difference unless you were treating it as a list, which you are not.

Carefully check the parenthesis and commas in your expression. You can use the template tester (available in Preferences / Toolbars) to help debug.

[Tanjamuse]

I have discovered the problem.

In my reading list I have 3 definitions: Uncertain,Interesting,Uninteresting.

The icon rule also selects those stories on the Uninteresting list.

[chaley]

Originally Posted by Tanjamuse

I have discovered the problem.

In my reading list I have 3 definitions: Uncertain,Interesting,Uninteresting.

The icon rule also selects those stories on the Uninteresting list.

"Contains" uses regex patterns, so use an anchored pattern

contains(field('#readinglist'), '^interesting$', 'y', ''),

[Terisa de morgan]

Originally Posted by chaley

"Contains" uses regex patterns, so use an anchored pattern

contains(field('#readinglist'), '^interesting$', 'y', ''),

An explanation:

• ^: Beginning of line
• $: End of line

In this case, as it is only a value, it matches.

[Tanjamuse]

That did the trick. Thanks both of you for the help.

[Tanjamuse]

If I wanted to use this rules on all the ships except those mentioned, what would the rule be then?