InfoQube IM - Community

Submitted by jan_rifkinson on 2013/07/04 10:27

So i created a field = 2_blog (This is boolean field that identifies items I've collected that I want to publish on my blog)

When i identify an item as 2_blog I want to auto assign "GTD_FoloUp"

If I understand push, i would have some equation in the "Item" field

If I understand pull, I would have some equation in the "2_Blog" field

It makes more sense to me to add a pull filter in "2_Blog" but this doesn't seem possible. I guess I should understand this by now but I don't

If it's only push, won't the "item" field eventually get overloaded with multiple equations?

in either case I don't know the proper syntax.

Thanks.

Comments

I dont know anything about pushing or pulling, but the equation can definitely go in the "2_Blog" field.

As to what the equation might be I aint the expert :D

have you had a look at the manual's equations page?

if something like that isnt already in there, it surely should be...

happy 4th to you!

I would simply use a push equation in the 2_blog field: AM:GTD_FoloUp=-1.

That should do the trick...

I you want to untick it should you untick 2_blog, use: AM:GTD_FoloUp=-1|E:GTD_FoloUp=0. This way, both fields will be in sync.

HTH !

Pierre, first thank you for the help.

I don't understand why the push equation appears to be in the negative.

Why couldn't it be:

AM:GTD_FoloUp=1|

E:GTD_FoloUp=0

Thanks for your help, Tom.

>I don't understand why the push equation appears to be in the negative.

-1 is the value to assign a checkmark (-1 = true in computer logic). Using a 1 may also work. You tell us !

It does work, Pirre. So much for computer logic ;-)

OK, so tell me what's wrong with this equation

If the word Tuscany appears in an item, add boolean y to field "Italy"

Placed in field Item

AME:Italy=HasKeyword(item,"Tuscany",-1)|

This is all gibberish to me & I copied it from another equation.

GRRR, ARGH....@##$%&*

Haven,t tried it but sseems to me that you should write :

AME:Italy=HasKeyword(item,"Tuscany",true)|

But maybe a m I wrong about that. Thee "true" here has nothing to do with checking the chekbox or not. In the provided functions it contrrols whether cases are important or not when looking for the keyword.

If the functions were commented, it wou ld probably be easier for the end user.

-------------------------------------------------------

Windows 8

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Thanks Armando. That worked fine, appreciate the explanation too.

If I understand it::

If function is for checkmark, then -1 = true

if function is not for checkmark, then true = 1

I don't know how you guys keep track of all this stuff. I only wish I did / could.

[EDIT : internet connection dropped before I could re-read my post. So, here...]

Hi Jan,

Actually, the problem is that in VBscript (the language used to script in IQ), true or false are used to assign values to Boolean variables. And in the function you're using above, the third parameter is a Boolean variable, not an integer. (This is something I saw by looking at the function in the Tools->Visual Basic Editor->System Code. Of course, I know how to code, so it helps...)

However, IQ's grids booleans don't use true/false but -1 (or 1) and 0 integers... And some other things (like carriage returns) aren't using the syntax I'm used to.... etc. So, in any case : yes, confusing.

Like I said : commenting the functions in IQ might help the users to know how to fill up the variables in the provided functions.

-------------------------------------------------------

Windows 8

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Armando, I think I understand my confusion but I KNOW I'm a hopeless case when it comes to this kind of thing.

But I thank you very much for your patient help.