0

Array formula

let arr := [item(URL2.'1 - EV master file', 0)];
for p in URL2.'1 - EV master file' do
if p.UID_Key = 'Link 3 ID' then
arr := array(arr, [p])
end
end;
if 'Link 3 ID' > "" then
arr := slice(arr, 1, count(arr));
arr.Model
end

How do i limit the result of the code above to only one record. In URL2 there might be more than one record with same UID, so maybe only take the last or filter just one. This could be alternate solution to my previous filter question. Thanks

Reply

null

Content aside

  • 5 yrs agoLast active
  • 628Views