I had hoped to use the “@ThisName” to get the suffix of the field name “Comment_1″ and hide it if the Field “Status_1″ is “Pending” by doing this :


Suffix := @Right(@ThisName; "_");
EmpListFieldName := "Status_" + Suffix;
Status_value := @GetField(EmpListFieldName);
@If( Status_value = "Pending";@Return(@True);@Return(@False));


but it didn’t work

finally traced it down to the “@ThisName” formula and the Help doc’s confirmed the bad news about the @ThisName formula:

Note A hide formula is not a field formula, even though it can be set from the field properties dialog. The hide formula applies to the paragraph containing the field. Since a paragraph can contain several fields, there is no “current field” in this context.

Instead, I will have to hard code the suffix reference, and replace the above code with:

Suffix := "1";
EmpListFieldName := "Status_" + Suffix;
Status_value := @GetField(EmpListFieldName);
@If( Status_value = "Pending";@Return(@True);@Return(@False))

which can be compacted down to


@GetField("Status_" + "1") = "Pending"


and it will need to be modified for every one of a large number of fields!!! (hence my wish to meta code).

I’ve add a “change this please on idea jam

see Ben Langhinrichs on Writing better hide-when formulas for more

Post from: False Positives

can’t use @ThisName in Hide-When formulas, LOTUS NOTES meta coding FAIL

Recent Blog Posts

30

False Positives on Planet Lotus Fri, Sep 25th 2009 9:56a Ian Irving [read] Keywords: domino lotus notes sntt community firefox google php planet lotus planetlotus planetlotus.org

95

Validating URL and Email Addresses with regexp in Lotus Notes Thu, Sep 17th 2009 9:57a Ian Irving [read] Keywords: lotus lotusscript notes sntt email php

52 1

can’t use @ThisName in Hide-When formulas, LOTUS NOTES meta coding FAIL Fri, Sep 11th 2009 12:31p Ian Irving [read] Keywords: dblookup document formula formula language lotus notes sntt idea jam ideajam ideajam.net php properties

198

Expanding Group Names for Lotus Domino using LotusScript Tue, Sep 8th 2009 10:09a Ian Irving [read] Keywords: acl document domino lotus lotusscript notes notes client rich text rich-text sntt php server

75

SNTT: a pseudo Computed for Display Rich Text Field in the Lotus Notes Client Thu, Sep 3rd 2009 4:16p Ian Irving [read] Keywords: document formula lotus lotusscript notes notes client rich text rich-text sntt idea jam ideajam ideajam.net php profile workspace

63

Sacha Chua shares her Lotus Notes mail merge from a Microsoft Excel spreadsheet Thu, Aug 27th 2009 9:40a Ian Irving [read] Keywords: document domino lotus notes sntt microsoft php

194

SNTT : using LotusScript to launch file attachements (EmbeddedObjects) in Lotus Notes Wed, Aug 26th 2009 10:13p Ian Irving [read] Keywords: admin document domino ibm lotus lotusscript notes notes client R5 R8 rich text richtext rich-text sntt application database office php profile security workspace

20

SNTT : Don’t hard code your Selectedable Years in a Lotus Notes dialog box. Thu, Aug 13th 2009 3:39p Ian Irving [read] Keywords: acl dblookup lotus lotusscript notes sntt php

16

SNTT adding http onto URL strings in Lotus Notes Thu, Aug 13th 2009 6:20a Ian Irving [read] Keywords: document formula formula language lotus lotusscript notes sntt java php

106

Stopping Copy and Paste, in Lotus Notes, selectivity in Views Thu, Jul 30th 2009 1:41a Ian Irving [read] Keywords: acl agent document formula formula language lotus lotusscript notes notes client sntt database php