Access to formula editor

Home

4D v20 R7

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 ).

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).