I’m having difficulty getting a table to display properly using my hide/when formulas. Specifically, the top and bottom rows which frame the table with the outside borders.
I have tried several forumlas, the last of which is below.
(Count = 1) | (Start != End) | (Start != End & Type != “Meeting”) | (Type != “Meeting”)
I basically need the top and bottom rows displayed whenever:
Count != 1 (counter to track form status)
AND either OR both of the following are true:
Start = End (two date fields)
Type = “Meeting” (radio button field)
Subject: RE: Can’t get hide/when to work properly
It’s weird how people can write their formula so clearly in English but they get all mixed when writing it in a programming language. You expressed it so clearly:
Count != 1 (counter to track form status)
AND & either OR both of the following are true: (
Start = End (two date fields) |
Type = “Meeting” (radio button field) )
To change it from Display When to Hide When, you negate it.
!(Count != 1 & (Start = End | Type = “Meeting”))
Subject: RE: Can’t get hide/when to work properly
Thanks for your help Andre. I did try negating it as well but I obviously still didn’t get it right. Thanks again.