Lotus Domino Designer 8 Help - Examples: @IfError

FORMULA LANGUAGE

Examples: @IfError
1. This agent tests the return value of an @DbLookup statement for an error. If the @DbLookup statement causes an error, the agent returns the text "Not available."

FIELD Phone := @IfError( @DbLookup(""; "Snapper" : "names.nsf"; "People"; @Right(Name; " ") + " , " + @Left(Name; " "); "OfficePhoneNumber"); "Not available")

This agent does the same thing, using @If instead of @IfError.

result := @DbLookup("";"Snapper":"names.nsf";"People"; @Right(Name;" ") + " , " + @Left(Name; " "); "OfficePhoneNumber"); FIELD Phone := @If(@IsError(result);"Not available";result)

2. The following code, when added to a Computed for display field, displays the price of the product entered in the "product" field, after a page refresh. Enter the text, "Enter product name here" as the default value for the product field. Once a user enters a product name in the product field and presses F9, the price is extracted from the Goods view, which contains the product name in the first sorted column and its price in the second column. If the product name is not recognized or any other error occurs during the lookup, the message, "Unable to retrieve requested price. Aborting lookup" displays. You could add a Get Price action button that contains the code: @Command([ViewRefreshFields]) to prompt the user to refresh the page.

@If(product="Enter product name here";0;@IfError(@DbLookup("" : "" ; "product/server" : "filename\\productdatabase.nsf" ; "Goods" ; product ; 2); "Unable to retrieve requested price. Aborting lookup"))

3. This formula, when added to the "Apply font" hotspot button, applies the font a user selects from the "fonts" Dialog list field to the text the user enters or highlights in the "Body" Rich Text field. The "fonts" field contains an @FontList function in the Use formula for choices box in its Field Properties box, which displays a list of available fonts. If no font was selected from the "fonts" field, an error message displays which instructs the user to select one.

@Command([EditGoToField]);"Body"); @Command([EditSelectAll]); @IfError(@Command([TextSetFontFace];fonts);@Prompt([Ok];"Error encountered";"You must select a font first"))

See Also

@IfError

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary