Forum Discussion

Winss's avatar
Winss
Qrew Trainee
3 years ago

Quickbase Code page to query a table and display records

I have created a code page which should query a table and display certain records using API -GenResults table. I am going to embed this code page in forms. Based on value in each record(in field - te...
APIs and custom code
Code Page
SimonH's avatar
SimonH
Qrew Cadet
If I am reading this correctly, you are misusing the javascript source tag's src parameter.
That is where you would put the URL for a valid JS file, not a QuickBase API url

What you want to do is pass that query URL to the code page as a query parameter, and then have a script on the page make the query and render the table

------------------------------
Simon H
------------------------------
Winss's avatar
Winss
Qrew Trainee
3 years ago
Hello Simon,
If i modify the 3rd line to shown below its going to pull out the records and display in code page.  What I am confused is passing the value in a formula text to the code page and display that code page at a record level using embedding technique of URL fields.  
<script src= "https://domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123%20t=1&query={%2729%27.CT.%27TYCU700%27}OR{%2729%27.CT.%27TYRD60%27}OR{%2729%27.CT.%a27TYTG8580%27}&clist=29.17.7.9.8.38.44.49&slist=17" lang="text/javascript">


------------------------------
Aswin Babu
------------------------------