grabformula
grabformula
DATABASE
,
FORMULA
,
RESULT

The grabformula statement evaluates a formula using data from another database.

Parameters

This statement has three parameters:

database – Database name.

formula – Text of formula.

result – Output value

Description

This statement evaluates a formula using data from another database.

This example assumes that the database has fields named Name, City and State (or fileglobal variables).

    local label
    grabformula "My Contacts",{Name+cr()+Address+cr()+sandwich("",City,", ")+State+" "+Zip},label

In this case the end result will look like a mailing address.

    Jack Wilson
    146 Orange Grove Place
    Pasadena, NM 40983

See Also

- Diagnosing a Formula embedded in a Form Object -- diagnosing problems with formulas embedded in form objects.
- formulatokencount( -- returns a count of the number of tokens in a formula.
- getformulatext -- converts a formula into text without special quote characters.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.