formulavalue(
DATABASE
,
FORMULA
)

The formulavalue( function calculates the result of a formula based on data in the current record of any open database. This is similar to the fieldvalue( function, but allows any formula to be used, rather than just a single field.


Parameters

This function has two parameters:

database – is the database that you want to grab data from. This database must be currently open. If this parameter is "" then the current database will be used.

formula – is the formula to be used to retrieve data. If the formula is specified inline in the function itself, it must be quoted (see Quotes). Otherwise, you can pre-store the formula in a field or variable.


Description

The function returns data from the specified database. Unlike the superlookup( function, the formulavalue( function does not search for the data, it simply uses whatever data is in the currently active record of the specified database.

This example grabs the current address from a Mailing List database, in mailing label format.

formulavalue("Mailing List",{First+" "+Last+cr()+Address+cr()+City+", "+State+
    " "+Zip+sandwich(cr(),Country,"")}

See Also


History

VersionStatusNotes
10.0NewNew in this version.