Hello! I have a question about a formula for hiding a panel with multiple conditions. I've attached a document with screenshots and details. Any help would be greatly appreciated.
I have simplified the control names a bit, but you should be able to follow.
!(jobType === "Member/Marketing/Community/Org." || (jobType === "Health Promotion (Disease Management)" && HP_Job_NewProject === "No"))
If the jobType equals "Member/Marketing/Community/Org." (true), then it gets inverted to (false), revealing the control
if the jobType equals "Health Promotion (Disease Management)" (true) AND
if the HP_Job_NewProject equals "No" (true)
it results in a true statement, which gets inverted to false, revealing the control. Every other option will hide the panel.
nmarples it worked! Thank you so much! What is the significance of the === as compared to the ==?
Glad to hear that it worked out!
If possible, could you mark my answer as correct?
As for the == and ===, the only difference is that === checks the type while == doesn't.
... Still there? Great!
You've already used some of these types in your work.
"Hello I Am A Sentence" is a String (notice the quotes), while...
4 is a Number.
The reason that you might want to use one over the other though... well that's where it gets a little more... philosophical.
Using something like == means that the statement
4 == "4"
4 === "4"
equals false, because it not only checks the values of the data being compared, but the types of those values! This is just like the sentence above, only with the types un-marked out. "The Number 4 is equal to the Word 4"!
nmarples Thank you very much. I wonder if this might help in some of required formulas I'll work on those next week.
One thing that I would recommend would be to name your controls with much shorter (and even more generic) names. It really helps to narrow down exactly what it is you're working with when what you're looking at isn't a long list of characters! The forums will be here if you run into any more speed-bumps!
nmarples Thank you
Retrieving data ...