formulafields(
formulafields(
DATABASE
,
FORMULA
)

The formulafields( function returns a list of fields used in a formula.

Parameters

This function has two parameters:

database – the database the formula is associated with. If this is omitted or is `""`, the current database is assumed.

formula – is the formula to be analyzed. 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 a list of fields used in a formula. The list is returned as a carriage return delimited text array.

For example,

    formulafields({alpha+cr()+bravo+sqr(Price)+upper(Name)})

will return the two fields that appear in this formula:

    Price
    Name

If the formula is associated with a different database (not the current database), you must explictly specify the database, like this.

    formulafields("Mailing List",{alpha+cr()+bravo+sqr(Price)+upper(Name)})

See Also

- formulaidentfiers( -- returns a list of identifiers (fields and variables) used in a formula.
- formulastrings( -- returns a data array of strings (text constants) used in a formula.
- formulavalue( -- 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.
- formulavariables( -- returns a list of variables used in a formula.

History

Version | Status | Notes
10.2 | New | Carried over from Panorama 6.0