U Man Genius docs

Scripting tips & tricks

Arrays in Ninox

Jacques TUR

Simple Arrays

Manipulating arrays of text or numbers is straightforward:

var myArray := ["a", "b", "d"];

index(myArray, "b");

myArray := array(myArray, ["c"]);

myArray order this;

Sorting can also be performed using order, sort, and unsort for text or number arrays. For more array-related functions, refer to the

Ninox documentation⁠

⁠

Two-Dimensional Arrays

Ninox does not support two-dimensional arrays directly. Instead, use an array of JSON objects. For example, sorting the array by the second element of the d2 field:

var myArray := [{'d2':["a", "Z"]}, {'d2':["b", "B"]}, {'d2':["c", "C"]}, {'d2':["d", "D"]}];

(myArray order by item('d2', 1));

⁠

Filtering Arrays

You can filter arrays similarly to the result of a select. For text or number arrays, use this to refer to the value being filtered:

var myArray := ["Jan", "Fred", "Jacques"];

myArray[this like "J"] order this;

For JSON arrays, use the key directly:

var myArray := [

{ 'prénom' : "Jan", nom : "Augustin" },

{ 'prénom' : "Fred", nom : "Baillot" },

{ 'prénom' : "Jacques", nom : "Tur" }

];

myArray[nom like "i"] order 'prénom';

⁠

Custom Operations on JSON Arrays

For JSON arrays, you can include a code block (in parentheses) to execute custom operations for each iteration. Like for in, the resulting array's type matches the last line of code in the block.

Example: Calculating the length of full names (prénom + nom):

var myArray := [

{ 'prénom' : "Leo", nom : "Martin" },

{ 'prénom' : "Paul", nom : "Garnet" },

{ 'prénom' : "Pierre", nom : "Dur" }

];

var nameLengths := myArray[nom like "i"].(