Links

Ninox operators

The most important operators for writing scripts
Operator
Description
Examples
:=
A "defined as equal to" operator assigns a value to a field or variable.
Text := "Hello world!"
let x := 1000;
x := 2
;
A semicolon ends a line. If you define variables (with let), the semicolon is also inserted automatically and subsequently by Ninox.
let x := 1000;
""
Double quotes highlight text, i.e., everything inside should be used as normal text.
"Hello" + " " + "world!" => Hello world!
Text := "Hello world!"=> Hello world!
''
Single quotes enclose table or field names that contain spaces or special characters so that Ninox detects they belong together.
'Total net' + " " + "(VAT not included)"
=> 425,00 € (VAT not included)
Note: 'Total net' is a field name in your database. "(VAT not included)" is text appended to the amount.
.
A dot lets you access fields of records or values of JSON objects.
For example, access all customer IDs in the Customers table with (select Customers).CustomerIDs.
--- ---
An alternative to double quotes (see above) is a 3 minus sign to help make dynamic text more clear.
---Hello world!--- => Hello world!