Forum Discussion

GabrielFigueroa's avatar
GabrielFigueroa
Qrew Member
5 years ago

Retrieve LookUp value

How is jQuery statement configured to access the value of a LookUp field from a Related table?
For instance, the Related Company Name is fid_21 but I need the actual company name which is showing to be fid_22.

The console.log shows fid_22 = undefined.

This only returns the Record ID # of the related Company Name table.
var scName = $("_fid_41").children("option:selected"). val();

------------------------------
Gabe Figueroa
------------------------------
​
APIs and custom code
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    5 years ago
    If you do a jQuery call already, you could instead just do a API_DoQuery of the parent table, with the fid_21 value being the Record ID, get the Company Name field value from there

    ------------------------------
    Ryan Stanford
    ------------------------------
    • GabrielFigueroa's avatar
      GabrielFigueroa
      Qrew Member
      5 years ago
      Thanks, Ryan, that's what I did.

      It seems a little like walking around the park rather than thru the park just to get to ice cream truck on the other side of the park

      I HIGHLY appreciate your time & confirmation on this question.

      ------------------------------
      Gabe Figueroa
      ------------------------------