Formula returning the ID number of the field not the value
A

Hello all, Any ideas why this formula is giving me the target record ID number rather than the value?

 

let x := 'Our SKU';
let priceMin := first(min((select 'Supplier List')['Our SKU' = x].'Item Price'));
first((select 'Supplier List')['Item Price' = priceMin].Supplier)

A

Ok- thanks David.

Just another thing. For some reason with thsi code the Supplier gets returned as teh ID of teh record. ie: Instead of saying 'Go-Pak' it just says 1. Any ideas why and how I get it to give the name?

 

let x := 'Our SKU';
let priceMin := first(min((select 'Supplier List')['Our SKU' = x].'Item Price'));
first((select 'Supplier List')['Item Price' = priceMin].Supplier)

Reply