Custom Column Recommendations

[chaley]

Originally Posted by Tanjamuse

Do you know if I can make a custom column based on a user category?

Originally Posted by BetterRed

That harks back to this problem

The template language cannot see user categories, so it isn't possible to use them in a custom column.

[Tanjamuse]

Originally Posted by chaley

I read the request as "add an icon if (some column) has more than 3 values.

You do this with a custom rule, something like:

program:
	cmp(count(field('tags'), ','), 3, '', '', 'someicon.jpg')

where you replace 'tags' with the lookup name of the fandom column and 'someicon.jpg' with the name of the icon file you want.

You were correct. Maybe I didn't explain well enough.

Where do I write that piece of code? In Advanced Rule under icons or?

[chaley]

Originally Posted by Tanjamuse

Where do I write that piece of code? In Advanced Rule under icons or?

Yes, as an advanced rule in the column icons preferences.

Note that if you can display multiple icons by returning a comma-separated list of file names as in 'foo.jpg, bar.png, mumble.jpg'

[Tanjamuse]

Have I done it correct?

Because it doesn't seem to be working.

[chaley]

Originally Posted by Tanjamuse

Have I done it correct?

Because it doesn't seem to be working.

No. You left off the word "program:".

[Tanjamuse]

It still doesn't seem to be working.

[chaley]

Originally Posted by Tanjamuse

It still doesn't seem to be working.

Works fine for me.

First point: I am sure that "FanDom" is not the lookup key for the column. Lookup keys start with the # character.

Second: are you sure about that image file name? Use the "Copy an icon file name to the clipboard" box to check the file name and, if needed, correct it.

[BetterRed]

Tanja - I think you need to change that Fandom to its internal name - eg #fandom

BR

[Tanjamuse]

Thank you both so much

What if there are only 2 different fandoms?

Edit:

Never mind, I actually figured it out myself

Thanks yet again

[Tanjamuse]

I have a new question:

Can anyone help me with what's wrong with this, since the star doesn't show up in the column.

program:
test(
or(contains(field('#ships'), "Lilly Rush/Scotty Valens", '', 'y')),
or(contains(field('#ships'), "Fran Fine/Maxwell Sheffield", '', 'y')),
'star.png',
)

I've also added the specifications for that custom column.

Thanks so much

[chaley]

Originally Posted by Tanjamuse

I have a new question:

Can anyone help me with what's wrong with this, since the star doesn't show up in the column.



I've also added the specifications for that custom column.

Thanks so much

First, the definition you show isn't for #ships. I assume that #ships is a text column.

I also assume that you want a star if #ships contains either "Lilly Rush/Scotty Valens" or "Fran Fine/Maxwell Sheffield". The following template does that.

program:
	test(
		or(
			contains(field('#mytextmult'), "Lilly Rush/Scotty Valens", 'y', ''),
			contains(field('#mytextmult'), "Fran Fine/Maxwell Sheffield", 'y', '')
		),
		'star.png',
		''
)

[Tanjamuse]

If I want more couples do I just copy the following:

contains(field('#mytextmult'), "Lilly Rush/Scotty Valens", 'y', ''),

And insert another couple?

[BetterRed]

Originally Posted by Tanjamuse

If I want more couples do I just copy the following:

contains(field('#mytextmult'), "Lilly Rush/Scotty Valens", 'y', ''),

And insert another couple?

Yes but you'll want this

contains(field('#ships'), "Lady Gaga/Tony Bennett", 'y', ''),

BR

Just bought it

[Tanjamuse]

Thanks both of you, yet again

[Tanjamuse]

Another question:

I don't know if I've done it correctly: