Forum Discussion

SiddharthAsapu's avatar
SiddharthAsapu
Qrew Member
7 years ago

Auto populate a field in quickbase by querying a table

I am very new to QB and helping out my team to modify an existing QB application. One of the requirement is to auto-populate the contract amendment field on contract table so that it displays the late...
Quickbase Automations
Tables and fields
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Use the IOL technique with code similar to this:

var dbid = "your app dbid here";
var dbidTable = "your table dbid here";
var apptoken = "your apptoken here";
$.ajaxSetup({data: {apptoken: apptoken}});
$.get(dbidTable, {
  act: "API_DoQuery",
  clist: "6",
  slist: "6",
  options: "num-1.sortorder-D"
}).then(function(xml) {
  var nextContractId = parseInt($("contract_id", xml).text(), 10) + 1;
  $("#_fid_6").val(nextContractId);
});