I have a field (TMAFA) with a dialog list of 4 options–Baby and the three listed below. I want the four related paragraphs to be hidden unless one is chosen. For the first one I choose baby and then use the following formula in the Hide Paragraph if true box:@If(TMAFA="Team Member Illness/Injury;
Team Member Family Death;
Team Member Death")
I can not get the paragraphs to hide and am not sure what I am doing wrong
For each paragraph use a ‘not’ situation - yeah, I know negative logic isn’t cool, but it’s shorter this way.To hide baby para, the hide when formula could be:
!TMAFA = “Baby”
To hide Team Member Illness/Injury para, the hide when formula could be:
This worked, thank you. One more question. I choose the situation I want, but can not get the corresponding paragraph to appear unless I hit the refresh key. Is there an easy way (I’m sure there is!) to make the paragraph appear after choosing the situation?
Go to the field properties of the field TMAFA. On the second tab, check the option “Refresh fields on keyword change”. With this option checked all hide when formulas will be recalculated each time you change the field value.
you don’t need to use an IF statement in a hide/when formula. The hide/when simply obeys a true result so if you want to hide the paragraph if the field contains a certain value you would just write it like this:
TMAFA = “Team Member Illness/Injury”
From your explanation I don’t know why you are including the other 2 items. Explain in more detail what you want/expect to happen.
Thank you for your help. I have one form for 4 different scenarios:
Baby
Illness/injury
Death of family
Team Member death
HR wants to open the page and have it blank, pick one of the 4 items and have the corresponding paragraph appear to have the items input. When looking at the form, only the applicable section will be visible.
Each paragraph must be addressed independently. A different hide-when formula must be used for each paragraph. Using the not (!) symbol allows a simple hide-when formula for each paragraph. If you don’t set a default value for your list, then using this method will hide all of the paragraphs until something is chosen.