Submitted by carloscadu on 2022/03/24 07:02

Hi, I'd appreciate your help.

I set the following conditional formatting expecting the main items font to become RED (ForeColor=&H0000FF) according to the ItemTags:

 

[ItemTags] startwith "a"

 

So given the tags listed in the screenshot below, I'd expect that any item with assigned tags aASK, aFOLLOW, or aTHINK would become RED.

However, it isn't working.

 

What could be going wrong?

 

Thank you,

Carlos

 

Conditional Formatting

 

 
 
 

Comments

Hi Carlos,

Can you provide more information ? Which field has conditional format ? Full view of the grid where it should be applied

Also, ItemTags is a special field, so this could also be the issue...

Which field has conditional format ?

=> The main "Item" field (ID 1)

 

ItemTags is a special field, so this could also be the issue...

 

=> ItemTags worked properly changing font color with "contains" parameter, like that:

[ItemTags] contains "1now"

 

So I'm getting there is no issue using ItemTags field itself in the criteria, but maybe the syntax is what I'm not able to elaborate properly using "startwith".

 

Any alternative syntax?

 

Thank you!

 
 
 
 
 

Hi Carlos,

I believe that the issue is that the Tags column shows tags as hyperlinks, and the conditional format uses the raw code, not the displayed text, so the tag is actually something like <a T#TagID>Tag1...

So... if you use contains=(">a") it should work. In addition, it will work when other tags are present 😎

[edit] Correct syntax is contains ">a" [/edit]

Pierre_Admin
IQ Designer

 

Thanks for the direction, Pierre!

As shown in the screen-recording, it is still not working: 

[ItemTags] contains=(">a")

But as reference [ItemTags] is operational, this syntax worked:

[ItemTags] contains "aASK"

🤷‍♂️

 

Conditional

 
 
 
How do I ?