Hi,

We've been using Ninox for a few years now. When we first started Tech Support created a Fiel Formula for us. Now it is not working.

Was getting errors saying files missing. Have re-inserted the missing fields but the formula action still doesn't work.

THis is the code.

let myid := this;
let start := number('Start Duty Number');
let endd := number('End Duty Number');
let n := start - endd + 1;
let i := 0;
let myduty := (select 'Duty Numbers' where number('Duty Code - GX') < start + 1 and number('Duty Code - GX') > endd - 1);
while i < n do
let dn := endd + i;
let mymy := myduty[number('Duty Code - GX') = dn];
if mymy.'count of link' = 0 then
let j := (create '70cl Duty Numbers');
j.('Distillers Record' := myid);
j.('Duty Numbers' := first(mymy.Id));
i := i + 1
else
i := i + 1
end
end

The Inputs were a Duty Start NUmber & Duty End number. this would then search the Duty Numbers Table to pick the numbers and then would create a record.

This is now not happening.

Would be great for some help.

Thanks