0

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

null
    • Hinpack Limited
    • Alex_B
    • 4 yrs ago
    • Reported - view

    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)

    • Customer Service Ninox
    • maja
    • 3 yrs ago
    • Reported - view

    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

  • 3 yrs agoLast active
  • 2Replies
  • 874Views