Formula editor features

An overview of all basic features the formula editor offers as of version 3.6.0

At the moment, the new formula editor features are available for the web app (app.ninox.com) as well as the Mac app.

Line numbers

Line numbers are displayed in the left margin of the formula editor window.

How to use

Line numbers are always visible by default.

Example

Line numbers are visible by default

Indentation

Indents a code block automatically.

Code formatting

Takes your code and prettifies it to conform to a consistent style. Wraps code and adds or removes white space when necessary.

How to use

Access the formula editor to format existing code, click OK to leave the editor. The next time you open the formula editor again, this code appears newly formatted.

Example

Code in the upper image is poorly formatted. After saving changes, code in the lower image is formatted consistently

Auto-completion

While you type, a pop-up appears next to the cursor displaying suggestions to complete your script.

How to use

To select the first option from the list, press the ENTER key.

To select another option, use the arrow keys, then confirm your selection with the ENTER key.

Example

Suggestions to auto-complete your script appear while you type

Syntax highlighting

While you type, text is highlighted in different colors.

Syntax	Color
String (text)
Keyword
Function
Built-in value
Variable/Table/Field
Operator
Number
Data type

How to use

To trigger syntax highlighting, type an expression.

Example

Different syntax is highlighted in its designated color

Breadcrumbs

The current location of the written code is displayed above the formula editor's contents.

How to use

The location is displayed automatically.

Example

The position of the code is displayed in the upper-left corner, just above the contents of the window

Error and warning marks

Displays errors and warnings while you script and suggest corrections.

How to use

While you type, gutter line numbers with erroneous code are highlighted and the code itself is underlined in red. To reveal the error message, hover above the line number.

When you make a syntax error, the formula editor only highlights the first error, even when more syntax error follow that first one. This happens because the following script cannot be parsed due to the preceding syntax error. When you make a reference error, the formula editor highlights each error independently of its position in the script. So, when a syntax error precedes a reference error, only the foregoing syntax error is highlighted.

Example

The line number highlighted in red and the erroneous code is underlined in red Hover above the line number to reveal the corresponding error mess

Search and replace

Search and replace text, variables, and expressions within a code block. Works for

• Match Whole Word,

• Match Case, and

• Use Regular Expression.

How to use

To search, enter text in the search bar or press CMD+F (macOS) or Ctrl+F (Windows).

Example

A preview of the search and replace feature

Brace matching and brace auto-completion

Highlights corresponding parentheses and automatically completes open parentheses.

How to use

To visually locate a parenthesis' match, use the arrow keys to select a parenthesis and highlight its counterpart.

To auto-complete parentheses, type an opening parenthesis.