4D Doc Center : Access to formula editor

Home

4D v14.3

Access to formula editor

You can use the formula editor in several contexts within the 4D database:

For global updates on a selection of records (see "Global updates" in Editing records).
For performing a sort by formula (see “Sorting based on a formula" in Order by editor),
For calculating a quick report column (see Associating formulas with a quick report).

In the Application environment, you can execute an update formula directly via the EXECUTE FORMULA command or display the formula editor via the EDIT FORMULA command.

Note: You can also use a formula when performing a query on database records. In this case, you use an advanced function in the query editor and not the formula editor (see Query by formula).