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 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
if not('recordsId' in [1,2,3,4,5,6,7,8]) then ...
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"
What do you want to achieve?