Hide Paragraph if formula is true

HCL Domino Domino Forum
1

Hi guys, this is my first topic created here. I want to make a small question about a problem I am facing. I wrote some “Hide paragraph if formula is true” formulas using @if function. The formula checks if one field has a specific letter for example “A” and based on it, that button has to be hidden. The problem I am facing is that the fields are not being hidden when that value is an “A”.My question is, Should I Check any special property in the button, in the form or may be in the fields with the letters?

Thanks a lot.

2

Subject: Hide Paragraph if formula is true

First, the hide formula has to evaluate to either true or false.Second, you need to refresh hide formulas before they will take effect. If the field being checked is a checkbox/radio button etc., you can set it (field properties) to refresh the document when its value changes. If not, you may need to write in the fileds onBlur event to force a refresh of the hide formulas.

Here is a test: If you put an “A” in the field, the button doesn’t hide, right? If you press F9, does it hide then? If so, your problem is with the second point above.

3

Subject: Hide Paragraph if formula is true

You don’t need the @if function in your formula. Just use the @Contains function. If it evalates true the paragraph will be hidden. eg. @Contains( fieldname ; “A” ).

4

Subject: Hide Paragraph if formula is true

Hi Martin,

A “Hide Paragraph when formula is true” formula works by using just the “Condition” component of an IF function.

@IF(CONDITION; True; False)

So if you have a Field:

name:TOAST, value:BURNT

And you wanted to test the value in a normal formula you would use:

@IF(TOAST=“BURNT”; “Throw Away”; “Spread with Vegimite”)

And the result would return: “Throw Away”, since:

TOAST=“BURNT” is TRUE.

If you wanted to hide a field that contains all of your topping options for the TOAST, you do not have to use the whole forumla, you only need the CONDITION component, therefore if you put

TOAST=“BURNT”

in the “Hide Paragraph” entry, your paragraph will be hidden until the value of the TOAST field changes to something else.

Hope this helps,

Regards,

Mat