Forum Discussion

RandyGibbons's avatar
RandyGibbons
Qrew Trainee
5 years ago
Solved

IOL working (JSON) would like to save to field in form

I was able to use IOL and read in the data from the JSON API using the model.js (below), pass a variable (satellite) and see the data in the console after pressing the button (props to Diebolt! and hi...
APIs and custom code
  • SamJones1's avatar
    SamJones1
    5 years ago
    Hey Randy,
    First off, I'd avoid Image on Load. It'll break at some point in the future.

    That said, if it's writing to the console successfully, you should be able to add this:

    $("#_fid_7").val(resp.latitude)​

    And that should add it to the record that's on the screen.


    ------------------------------
    - Sam

    ______________________________________________
    Sam Jones
    Vice President, Product and Technology
    he/him

    The Data Collaborative, Inc.
    sjones@datacollaborative.com
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
    ------------------------------
SamJones1's avatar
SamJones1
Qrew Cadet
5 years ago
Hey Randy,
First off, I'd avoid Image on Load. It'll break at some point in the future.

That said, if it's writing to the console successfully, you should be able to add this:

$("#_fid_7").val(resp.latitude)​

And that should add it to the record that's on the screen.


------------------------------
- Sam

______________________________________________
Sam Jones
Vice President, Product and Technology
he/him

The Data Collaborative, Inc.
sjones@datacollaborative.com
366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
------------------------------
RandyGibbons's avatar
RandyGibbons
Qrew Trainee
5 years ago
Thanks Sam, worked like a champ!  Just need to be in Edit mode for it to populate, but no issues.  Added it after the bottom console.log lines.

What other solution would you suggest based on this?  I know there are pipelines, but our org has them disabled at the realm level.

Randy

------------------------------
Randy Randy
------------------------------
  • SamJones1's avatar
    SamJones1
    Qrew Cadet
    5 years ago

    Randy,
    I'd lean toward having a url formula like this:

    urlroot() & "db/" & appid() & "?a=dbpage&pageid=5&satellite=" & [satellite]

    Pass that off to a code page (in this case page 5), have the code page make the API call, then call the following:

    var targetTable = "dbid of the table you want to create a record on"

    window.location.href= 'https://quickbase.com/db/' + targetTable + '?a=api_genaddrecordform&_fid_7=' + resp.latitude;


    That'll open a new record form with the value pre-populated. If you want to do that with an existing record, set up a call with me and we can talk through it.

    https://calendly.com/samrjones



    ------------------------------
    - Sam

    ______________________________________________
    Sam Jones
    Vice President, Product and Technology
    he/him

    The Data Collaborative, Inc.
    sjones@datacollaborative.com
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
    ------------------------------