Constrain an array
Ninox Profile

Hi friends!

i have a table with a lot of records. I have an array of numbers which is result of some formula. In the Constraint field i want avoid record which id contains in array. 

let recordsId:=number(id);

let myArray:=[1,2,4,5,7,8.....n] ;

i wish that formula would

for i in myArray do

recordsId != item(myArray,i)


but it doesnt work lol

Ninox Profile

Try this:

if not('recordsId' in [1,2,3,4,5,6,7,8]) then ...


Ninox Profile

Birger, it doesn`t work neither with staitetment nor values. 

even when i try 

if not(5 in [1,3] ) then - it always alert "symbol expected:then"

Ninox Profile

What do you want to achieve?