@ThisName doesn't work in hide-whens

HCL Domino Domino Forum
1

I have a table with two columns and fields:

IPN_1 A_1

IPN_2 A_2

etc

I want the A_ fields to hide when the IPN_ fields are blank so I wrote the following code into the hide-when of the A_ fields, but it always hides the field.

row := @Right(@ThisName;“_”);

thisIPN := @GetField(“IPN_”+row);

thisIPN = “”

Has anyone got @ThisName to work in hide-whens?

Regards

Martin

2

Subject: RE: @ThisName doesn’t work in hide-whens

The problem in this case is that the hide formula is not considered a formula of the field. There is no field context in which this formula executes. The hide formula applies to the text paragraph. In your case, perhaps there’s nothing in the paragraph except one field. But there might be several fields and some text or other objects besides. In that case, to which field does @This… refer?

So there’s really not much you can do about this; just write a different hide formula for each row.

Alternately, refer to this download for ways to edit data in tables without having dozens of separate fields.

3

Subject: @ThisName doesn’t work in hide-whens

Try this and see if it helps:

row := @Right(@ThisName;“_”);

thisIPN := @GetField(“IPN_”+@Text(row));

thisIPN = “”

This will probably fail as the help file states:

“This @function returns null outside a field formula.”

I would interpret this to mean it will not work in a hide-when formula because this is not a fild formula.