Forum Widgets
Recent Discussions
Code Page for User to Search And Return a Report Visual
I have the following Code page. I have successful code where the user inputs data into 2 fields and QuickBase data is returned. However, where I am struggling is instead of data being returned, a report being returned ideally or I have a formula URL field that can be returned but needs to be an iframe. <!DOCTYPE html> <html> <head> <title>Quickbase Data Retriever</title> </head> <body> <label for="inputField">Enter Record ID or Search Term:</label><br> <input type="text" id="inputField"><br><br> <button id="retrieveButton">Retrieve Data</button> <div id="result"></div> <script> document.getElementById('retrieveButton').addEventListener('click', function() { const inputValue = document.getElementById('inputField').value; const appDbId = 'XXXXXXXXXXX'; // Replace with your Quickbase App DBID const tableDbId = 'XXXXXXXX'; // Replace with your Quickbase Table DBID const targetFieldId = '6'; // THIS IS THE formula URL field const queryFieldId = '37'; // Replace with the FID of the field to query against const userToken = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'; const apiUrl = `https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? a=API_DoQuery&query= {'${queryFieldId}'.EX.'${inputValue}'}&clist=${targetFieldId}&usertoken=${userToken}`; ****I have also tried report is qid 6 const apiURL='https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? qid=6&nv=1&v0= {'${queryFieldId}'.EX.'${inputValue}'} fetch(apiUrl) .then(response => response.text()) // Quickbase returns XML .then(xmlStr => { // Parse the XML string into a DOM object const parser = new DOMParser(); const xmlDoc = parser.parseFromString(xmlStr, "application/xml"); // Extract the value inside <possible_url> const statusNode = xmlDoc.querySelector("possible_url"); if (statusNode) { document.getElementById('result').textContent = statusNode.textContent; } else { document.getElementById('result').textContent = "No field found in response."; } }) .catch(error => { console.error('Error:', error); document.getElementById('result').textContent = 'An error occurred during the API call.'; }); When I call the formula URL field I get this so 1) is there a way instead of the URL being retrieved to have it in a iframe so that the report visual is shown? 2) Is there a way to instead filter the report for example: const apiURL='https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? qid=6&nv=1&v0= {'${queryFieldId}'.EX.'${inputValue}'} (this URL does work: https://xxxxxxxxxxxxxxxx.com/nav/app/xxxxxxxx/table/xxxxxxxx/action/q?qid=6&nv=1&v0=Minnie123 (Minnie123 would be the user's input to filter/query based of) and then have visual show in the html? The report does have a filter of "ask the user"
Transferring Field Data to Another Record
Hello, Is it possible for me to transfer quantity data on one record to another record? As an example, Record A has 10 laptops. Record B has 5 laptops. I would like to transfer 2 laptops from Record A to Record B. I've tried different methods, but I keep hitting a wall.
Display Summary Table in Related Child Records
How can I display a parent summary table report in each child record? The report, screenshot below, includes all subprojects (the child records) related to a project site (the parent). I desire this report in the child table to display the related subprojects.XLSX import to 2 Linked Tables?
Is there an easy way to accomplish this? Say as an example: Table1 - LEAD_NAME, PHONE, CONTACT_NAME Table2 - LEAD_NAME, CALL_DATE, NOTES Table1 can link to many Table2 If I create an xlsx sheet with all the relevant fields, can I do a mass import of leads and or calls (together) with a single upload? Or two uploads might make more sense so it doesn't duplicate leads? LEAD1, 555-555-5555, Bob, 09/17/2025,"Good Call" LEAD1, 555-555-5555, Bob, 09/17/2025,"Bad Call" I am curious how the linking would work here. I assume a pipeline might be needed? but before going down that path I wanted to see if I am overlooking an easier way.
Add new record button
At the top of the app there is a button that says "Add new record in any table". When a user clicks this button a drop down of every table is shown to them, even tables I have hidden from their role. Is there a way to remove this button completely or at least hide the tables I don't want them seeing?
Format Numeric Value 2 Decimal Places
Hello, I have a Formula Text that calculates and displays data based on the numbers users enter in two other numeric fields. Example: When a user enters a number in my Numerator and Denominator fields, my formula field divides those numbers and then displays the answer in the Percentage field (as shown in the screenshot below). Is there a way to format the answer to two (2) decimal places, so it's shown as something like 7.33 and not 7.3333333 ? Please let me know. See the code I used for my formula field below: var Number Numerator = [Numerator] ; var Number Denominator = [Denominator] ; ToText(($Numerator / $Denominator) & " %")
Updating a Field on Record Save Rule Using New Forms Rule Builder
I have many forms using the old form builder with "On Record Save" rules built to update a field value when a user saves a new record. Very simple in the old form rule builder interface. I am building a new form in the new form builder interface and am trying to create an On Record Save rule but can't see how to do this. Any help would be much appreciated. My rule is pretty simple, When the user saves the record change a field value to "x" on save. Thanks - Brian
Need to display hours and minutes within a TAT formula
I am using the formula below for a duration TAT. I have checked off the HH:MM:SS for the type and it is still displaying 0:00:00 for things that are one hour from rec'd to acknowledged time entered Days(WeekdaySub(ToDate([Acknowledgment Date/Time]),ToDate([Communication Received Date/Time]))) Do you have any suggestions on how to get the TAT to display accurately? Thank you Jill
