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!