Discussions

Expand all | Collapse all

Send information within Quickbase to an external URL

  • 1.  Send information within Quickbase to an external URL

    Posted 02-16-2019 22:12
    Well, I haven't been around here for 1 year since my coop ended at the place I was at that was using Quickbase but they asked for help on something so now I got some questions with some more advanced stuff. 

    Scenario

    Sister company has custom reporting software to auto fill documents.We would like to use it as well. I just need to get the info out of Quickbase and send it to the URL I have been given.

    My Research

    From what I have gathered searching, this will take a custom code page, since I can click and API call to get an XML dump on my page natively but I can't redirect it  natively

    I have two options from reviewing the API, either get record info or do query. Given I do not need to get all of the fields out of a record, I feel that do query is my best option.

    Desired Method of Use

    I have made so many nested URL buttons, for user friendliness, I would like to keep it a button. So from what I gathered, I will have them click the button that loads the custom code page to send the data.

    First Step

    I am now starting to work on a hard coded page. In this page, I am essentially going to hard code 

    <query>{3.EX.6201}</query>

    Which should return the information from only one record as record ID 6201 is distinct since it is the primary key for that table(for the time being I am just returning one field till I know it is working). I will know its working because I can keep swapping record ID I am hard coding and watch the field I am returning changing.

    So the real challenge I am asking is, in a formula URL button that will load the custom code page, how can I pass the record ID from the record they are in to the API request as something like 

    URLRoot() & "db/" & [_DBID_CLAIMS_OR_PROJECTS] & "?a=API_DoQuery&udata=mydata&query={3.EX." & [Record ID#] & "}&clist=6.7&fmt=structured"

     Won't work in a code page


  • 2.  RE: Send information within Quickbase to an external URL

    Posted 05-16-2019 18:13
    is the custom code page HTML or a JS page that's executed?

    if it's HTML it can be passed as a parameter... if you simply have JS executing on page QB has a global variable called kRid... it is the record ID of the current page.

    for JS code pages I generally go something like:

    const RecID = kRid;

    and then I can use RecID anywhere in my JS code...


  • 3.  RE: Send information within Quickbase to an external URL

    Posted 05-16-2019 19:29
    There is also this. Easier to link than explain, scroll to the bottom.

    https://community.quickbase.com/quickbase/topics/access-record-data-from-an-html-page-via-api-call