0

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!

Reply

null