InfoQube IM - Community

Submitted by jan_rifkinson on 2009/04/22 09:03

I'd like to

Use the word "Lmsg" in an item & have it automatically assigned to boolean 'Pending'

Thanks

Jan Rifkinson

Ridgefield CT USA

Comments

Do you want to use a Smart Fields (aka smart folders) or auto-assign rules?

Both are possible, but keep in mind that auto-assign rules against the Item field will be executed whenever something is entered in the Item field, which may (or may not) have an impact on the performance.

To use auto-assign, add the following function to the VBScript

Function HasKeyword(Fi, keyw, CaseSpecific)
dim myFi, CompareMethod

HasKeyword=0
if CaseSpecific=true then CompareMethod=1 else CompareMethod=0
myFi=trim(Fi & "")
if instr(1,myFi,keyw,CompareMethod)>0 then HasKeyword=true
End Function

And in the Item field, add the following to the Auto-assign:

AM:Pending=HasKeyword(Item,"Lmsg",true)

(add or modify to the item field will check pending if item has "Lmsg". If you want to clear Pending when the item is erased, Add the E flat (i.e. AME:...))

Sounds like I may want smart field (folder). How would that work?

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Besides my first question that was not answered, I now have a 2nd question.

I added

AM:Pending=HasKeyword(Item,"Lmsg",true)

to field = item

Then I created a test item w Lmsg in it

the item was marked Pending

Then I tried to delete the test item but now it won't delete.

Error: incorrect use of null

Suggestions on how to get rid of test item

Edited 04/22/09 07:06 pm another one of those things solved by closing & re-opening program

Thank you.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

I created many such items and was not able to reproduce the problem. I'll keep an eye open for it though