InfoQube IM - Community

Submitted by jan_rifkinson on 2009/06/11 10:16

Current Auto assign for Boolean Pndg field

A:WikiTag=AddKeyWord(WikiTag,"{pndg}")|E:WikiTag=RemoveKeyWord(WikiTag,"{pndg}")

I also want to add

when text contains word 'Lmsg', then Pndg is 'yes'

What's the syntax for this combined w the current statement?

bumped 06/11/09 09:23 pm EDT

Thanks.

Jan Rifkinson

Ridgefield CT USA

Comments

I don't have the time to test it, but you can try using the HasKeyword VBScript:

AM:Pndg=HasKeyword(YourTextFieldToSearch,"Lmsg")|E:Pndg=

Try it and report back.

> when text contains word 'Lmsg', then Pndg is 'yes'

Which text ?? The item text ? the wikitag text ??

Item text

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

then replace "yourtextfield" (in Pierre's post) with the item field.

Did you try it ?

yes & it produced an error

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

This works fine:

AM:Pndg=HasKeyword(Item,"Lmsg",-1)|E:Pndg=

(In my other post, I forgot the ending: ",-1")

Last parameter should be -1 for case specific and 0 otherwise

Nice one.

Maybe Jan should also be told that removing the keyword "Lmsg" from the item field will result in pndg=no

Consider him told.

Actually, there's another setting that I have that changes pndg --> no when it is marked done. Item background & font also change color like magic.

Now if I could just learn to figure this stuff out by myself I would be less of a PITA but I don't hold out much hope for myself in this regard.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Is that a question for how to do ::

> [...] changes pndg --> no when it is marked done. Item background & font also change color like magic.

Or are you describing something you already did yourself ?

Since the actual field is called 'GTD_Pndg' I changed the equation as follows:

A:WikiTag=AddKeyWord(WikiTag,"{pndg}")|E:WikiTag=RemoveKeyWord(WikiTag,"{pndg}")|A:ItemColor=&HCAFFFF|E:ItemColor=|AM:GTD_Pndg=HasKeyword(Item,"Lmsg",-1)|E:GTD_Pndg=

The result is that nothing happens but no error either

However, if I manually check GTD_Pndg, the rest of the formula works ok, i.e.

the item changes color

the wikitag {pndg} Is attached

Changing GTD_Pndg to 'no' removes background color & wikitag

Likewise marking it 'done'

I tried the last equation by itself, i.e.

AM:GTD_Pndg=HasKeyword(Item,"Lmsg",-1)|E:GTD_Pndg=

and it did not work here.

Since it is working for you, I am undoubtedly doing something wrong

Maybe you can try the entire formula & see if it still works for you.

Thank you.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

This is because, this part should be in the item field (auto assign rules) :

AM:GTD_Pndg=HasKeyword(Item,"Lmsg",-1)|E:GTD_Pndg=

And this one should be in the GTD_Pndg field (auto assign rules) :

A: WikiTag = AddKeyWord ( WikiTag,"{pndg}" ) | E: WikiTag = RemoveKeyWord ( WikiTag,"{pndg}" ) | A:ItemColor=&HCAFFFF | E:ItemColor=

I can explain why if you don't understand.

Armando, thank you.

If you hadn't pointed out the logic of this I would never have figured it out (probably) but let's see if I got this right:

AM:GTD_Pndg=HasKeyword(Item,"Lmsg",-1)|E:GTD_Pndg=

refers to a condition in the item

A: WikiTag = AddKeyWord ( WikiTag,"{pndg}" ) | E: WikiTag = RemoveKeyWord ( WikiTag,"{pndg}" ) | A:ItemColor=&HCAFFFF | E:ItemColor=

refers to a condition affecting the GTD_Pndg field, i.e. it is changed to yes (or no)

Essentially between these two equations:

the first one can trigger the second one

but

the 2nd one doesn't trigger the first one

Am I close?

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1