4D Doc Center : Access to formula editor

4D v12.4

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 query by formula (see Query by formula)
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),
For setting chart values (see Adding a formula).

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.