2

Create nested array in the form [[51.12344,34.876342],[26.987430,45.123459]]

Sometimes third-party programmes require data in the form of a nested array.
Ninox is unfortunately not able to create these simply with the array function.
However, thanks to Leo's ingenuity, it is possible to create a nested array with Ninox on-board tools.

I assume here 2 locations, from which the coordinates are to be sent as a nested array.

Here is the example script.
let myArr := [{
            key: [lat_1, long_1]
        }, {
            key: [lat_2, long_2]
        }];
let myArr2 := for i in myArr do
        i.key
    end;
formatJSON(myArr2)

The result of this script looks like this:

[[52.55837726356497,13.339076042175293],[13.803751949709243,100.58085322380066]]

 

It can be reproduced in the attached sample DB.

Reply

null

Content aside

  • 2 Likes
  • 11 mths agoLast active
  • 50Views
  • 1 Following