, )

---

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