Pattern List?

[JTSmith]

I have a table called Quote, a table called Properties, and a table called Phone Calls.  Quotes layout shows a portal of properties, and I hit a button on each portal row to make a phone call, which shows in the call portal.  It puts the name of the property in a log field.  I'd like to do some conditional formatting on the Properties portal that turns the text a color IF the name of the property is in the log.  I can't seem to figure this one out...  Any advice would be greatly appreciated.  

[eos]

Try

 

not isEmpty ( FilterValues ( Logfield ; portal::property ) )

[jbante]

Also try:

not IsEmpty ( FilterValues ( Portal::property ; Table::LogField ) ) 

This IsEmpty ( FilterValues ( ... ) ) construction seems to be the de facto standard way to check if a value is in a return-delimited list, but the performance is best when the list you expect to be shorter — such as the one-value Portal::property field, in this case — is the first parameter of the FilterValues function.

[JTSmith]

Thanks EOS!