0

Constrain an array

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)

end;

but it doesnt work lol

3 replies

null
    • Birger_H
    • 4 yrs ago
    • Reported - view

    Try this:

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

    Birger

    • agiorno
    • 4 yrs ago
    • Reported - view

    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"

    • Birger_H
    • 4 yrs ago
    • Reported - view

    What do you want to achieve?

    Birger

Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 1039Views