1. Are you paying attention to capitalization? Look at your two references to Invoice. I have found that sometimes my equations seem overly sensitive to this. Not sure if this still applies in W3 as I haven't changed my equations for a while.
2. Should this [itemcolor is &H99CCFF] be this [Itemcolor] is &H99CCFF? Again there is a difference with caps. The I and C in itemcolor.
Thank you Pierre. Really appreciate it but...... so many rules that the average user will never be able to harness some of the real power of IQ. Can't this stuff be simplified?
I don't want to appear ungrateful 'cause I'm not. Just sayin'.....
It's like the difference between using The Bat! & Thunderbird filters. It's like day & night.
Meaning Thunderbird filters, constructed in "english" rather than formulas, is infinitely more user friendly & accomplish the same thing(s).
I haven't looked @ The Bat! filtering for a few years since I moved over to Thunderbird (for this very reason) so they may have changed but early filters were constructed by equations. They may have simplified filtering to broaden their market share as The Bat! -- much like IQ -- is a very powerful program, safe & capable of almost anything.
So now I'm trying to do the following:
when I check boolean field paid
I'd like IQ to
insert current date into Date field DateDone
I added equation
A:paid=
in the DateDone equation field w/o results
What should I be doing instead?
Maybe I just have a block about this stuff as I continue to ask VERY basic questions even after all this time but at some level, I think I represent the wider potential audience for IQ
I won't address the filters problems as this is for Pierre -- and it's probably related to the "named filters" project/features.
As to insert current date into DateDone field when Paid is checked : Logically, what you want is for Paid to act on DateDone, right ? so the auto-assign equation must :
-...be in Paid, not in DateDone.
- assign a value to DateDone, since that's what you want to do. Right now you're assigning a value to Paid
- assign at least some values. Right now it assigns nothing--> A:Paid=nothing
So in Paid, just add this
A:DateDone=now
Alternatively, you might want to get rid of seconds :
A:DateDone=int(now)
(technically, what int() does, is to return the integer portion of a number. Dates are stored as Real numbers, where the decimal part represents fractions of a day)
Alternatively, you might want to also add a line so that the DateDone field emptied when Paid is unchecked :
A:DateDone=int(now) |
E:DateDone=
If you check out the sample DB, you'll see that there are other equations you could use as models. It's true that more sophisticated auto assigns aren't always trivial when you don't know any VB. But... then if someone has a UI suggestions to allow all these possibilities, it would be nice to see.
Armando, Thank you VERY MUCH for the explanation about how to accomplish what I wanted to do.
Both you & Pierre have offered really clear directions & explanations.
I must have fooled around with this thing for more than an hour before posting. I feel like a REAL DUMMY as it's so logical but I just don't grasp it so I continually return to the forum every time I have one of these issues.
Comments