query using a variable in html page
<script> var a=1594; console.log(a) </script> <script lang="javascript" src="https://tsemerge.quickbase.com/db/ DBID?a=API_GenResultsTable&apptoken=APPTOKEN&jht=1&query={'29'.EX.+'a'}AND{'6'.XEX....
Forum Discussion
This is how I would do it. note you can wrap URL in a var or just use the DBID if used within the app.
var query= "{'29'.EX.'" + kRid + "'}AND{'6'.XEX.''}AND{'7'.EX.''}OR{'7'.AF.'today'}";
$.get(DBID, {
act: "API_GenResultsTable",
query:query,
clist:"30.20.14.6.7.8",
slist: "6",
options:"sortorder-A"
}, function(xml) {
$("#results").html(xml)
})
var query= "{'29'.EX.'" + kRid + "'}AND{'6'.XEX.''}AND{'7'.EX.''}OR{'7'.AF.'today'}";
$.get(DBID, {
act: "API_GenResultsTable",
query:query,
clist:"30.20.14.6.7.8",
slist: "6",
options:"sortorder-A"
}, function(xml) {
$("#results").html(xml)
})