Individual Records Window
Posted: 18 Oct 2012 10:11
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.
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.