HH>Quick Base does not support custom JavaScript-based ajax operations on the page
Luckily, all browsers support "
JavaScript-based ajax operations on the page" so it is irrelevant where or not QuickBase supports it. In fact, all modern web applications are predicated on this feature (AJAX calls without reloading the page).
Instead of jamming JavaScript into your formulas you should use the
IOL technique and place all your script in a code page. Writing formulas that directly include JavaScript is only going to introduce syntax errors and difficult debugging sessions because of all the character escaping that is required. It is simply not worth the trouble to place hand crafted script directly into QuickBase formulas. The IOL technique provides a clean and easy to use method of jumping out of the formula scope and placing all your functional JavaScript into a code page.
When using a button with the IOL technique you append a <a> element to the IOL field using a formula like thisL
[iol] & "module.js" & [/iol]
&
"<a class='QBU_Button Vibrant Success' " &
" data-rid='" & [Record ID#] & "'" &
" data-name='" & [Name] & "'" &
">Button</a>"
This formula loads the code page "
module.js" and further displays a button with the label "
Button". Field values (here [Record ID#] and [Name]) are stamped into the <a> element as
data attributes.
Within the code page you can detect button click events and retrieve the data attributes as indicated below:
(function(){
var dbid = "";
var dbidTable1 = "";
var apptoken = "";
$.ajaxSetup({data: {apptoken: apptoken}});
$("a.QBU_Button").on("click", function(event) {
var rid = this.dataset.rid;
var name = this.dataset.name;
console.log("rid=", rid);
console.log("name=", name);
// your custom code here
});
})();One issue you should keep in mind is that if your API calls changes a field value that is currently being displayed you should immediately reload the page so that you are not displaying the old value of a field. Using the API from a page should not create a situation where stale information is being displayed to the user.
