Page 2 of 2

Individual Records Window

Posted: 18 Oct 2012 10:11
by tatewise
When I tried it, your example produced Expression is not valid.

So, similar to my earlier example using the =IsTrue() function:
=IsTrue( Exists(%...%) or Exists(%...%) or Exists(%...%) )

You need to use:
=IsTrue( ContainsText(...) or ContainsText(...) or ContainsText(...) )

When I have a moment I will update the Flags & Icons Worked Examples with examples involving =ContainsText() and =IsTrue().

Jane and others do run FH courses from time to time, but they usually cover a wider set of features than just Expressions, Data References, and Functions.

In the meantime, have a look at Understanding Data References and Understanding Functions.

Individual Records Window

Posted: 18 Oct 2012 23:31
by Robert129
Mike
Thank you very much. I hadn't actually loaded my version and was awaiting your comments as to whether it was correct or not.
I have now downloaded your version and confirm that all seems to be working perfevtly.

Once again my gratitude for your assistance.

I will also look Data References and Functions.

Robert