Formula returning the ID number of the field not the value
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)
2 replies
-
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?
l
et x := 'Our SKU';let priceMin := first(min((select 'Supplier List')['Our SKU' = x].'Item Price'));first((select 'Supplier List')['Item Price' = priceMin].Supplier) -
Dear Alex,
A good opportunity to get direct help for your request is our webinar "Open Office hours" on Tuesday from 18 to 19 o'clock CEST.
Please raise your hand there (virtually), then we will provide you a live support.You can join our free webinar directly via the following link:
https://us02web.zoom.us/webinar/register/WN_ksexSiXERMez8hFXqFR_Dw
Thank you very much.An overview of the schedule and content of our webinar can be found here:
https://ninox.com/en/webinar
Content aside
- 4 yrs agoLast active
- 2Replies
- 874Views