We have a standard letter that we send to new clients. Some of the information in that letter changes depending on whether they are currently in jail or out on bond. Previously, we had a user variable (called “BondOrJail”) that we used to define which text was shown. It worked great!
We have now started capturing that information (whether they are out on bond or in jail) in our database and want to use that information to trigger the change in text. Because some of our records pre-date the expansion of the database, we want the option of being able to trigger it by EITHER the database variable (database.casedetails.BondStatus) or the user variable (“BondOrJail”). I got it to work with “conditional text” by using this formula:
((BondOrJail == “Jail”) or (BondOrJail == “JAIL”) or (database.casedetails.BondStatus == “JAIL”) or (database.casedetails.BondStatus == “Jail”))
If the condition is “TRUE”, then it prints the word “Jail”. If none of the variables meet the criteria, then it prints the word “Bond”. It works swimmingly.
Several paragraphs need to be hidden in the client is not in jail, and for those I used this formula:
((BondOrJail != “Jail”) and (BondOrJail != “JAIL”)) and ((database.casedetails.BondStatus != “JAIL”) and (database.casedetails.BondStatus != “Jail”))
This SHOULD make the paragraph disappear entirely if none of the values has “JAIL” or “Jail”. (The variations are needed because not everyone has been consistent in their capitalization…) It does not work; instead, the paragraph only disappears based upon the “BondOrJail” value, and not the database value. (So if “BondOrJail” equals “Jail”, it disappears, even if “database.casedetails.BondStatus” equals “Jail”.)
It works if I do it as:
((BondOrJail != “Jail”) and (BondOrJail != “JAIL”))
And it works if I do it as:
((database.casedetails.BondStatus != “JAIL”) and (database.casedetails.BondStatus != “Jail”))
But if I use both, it doesn’t work.
I’ve tried without the outside parentheticals. I’ve tried with the whole thing in parentheticals. I’ve tried every variation I can think of. What am I doing wrong here?
(This is in LibO 7.0, Win 10 64 bit.)