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 - test temp inventory query) the contents in the table changes. Below is the code page code <html> <head> <script src= ~test temp inventory query~ lang="text/javascript"> </script> <style> td.m { font-family:verdana; font-size:70%; } td.hd { font-family:verdana; font-size:70%; font-weight:bold; color:white;} </style> </head> <body> <h1>Example</h1> <table cellpadding=5 bgcolor=lightgreen> <tr> <td> <script lang="text/javascript"> qdbWrite(); </script> </td> </tr> </table> </body> </head> </html> The third line, value of src determines the query. ~test temp inventory query~ is the field where query is created as a formula text . The value in formula text looks something like this https://Domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123 t=1&query={'29'.CT.'TYCU700'}OR{'29'.CT.'TYRD60'}OR{'29'.CT.'TYTG8580'}&clist=29.17.7.9.8.38.44.49&slist=17 But the contents are not getting pulled correctly. Which is best way to pass value in field to the QuickBase code page and display the link to code page as embedded in the same form. ?
How to download File attachments using API ?
I am trying to download the files from my Quickbase table using the download file API (https://developer.quickbase.com/operation/downloadFile), but I only get the data in base64 format. How do I download the file itself ? ------------------------------ Hemanth ------------------------------
Update Date & Time field with URL Button
Hey Community, I'm working on some cool approval functionality and want to be able to use a URL button field to 1, change the status and 2, update the date and time of a field. I have everything worked out excepted for the date and time stamp of "today" or "now" & "fid_67="Today()" what's is the proper formula to update this field to the current date and time? Let me know if you need any additional information. Thank you :) ------------------------------ Jack Woods ------------------------------Documentation on using JavaScript in quickbase
Where is the documentation on using javascript in QuickBase? I was searching in google for javascript in QuickBase documentation but I couldn't find any. Please give me the link to the documentation. ------------------------------ Aswin Babu ------------------------------
Create a simple edit record button
I am attempting to create a button to use on a table or a form to allow not so familiar users to find easily. I am using this formula "?act=API_EditRecord" in a URL-formula field but am getting an error. Is the URL-Formula field the way to go? ------------------------------ Michael Hall ------------------------------
2022 QuickBase REST API Starter Development Kit for PHP.
Hi all, We use QuickBase for many things and love the tools it offers. We use WordPress to manage our ECommerce store and needed a way to communicate and update our QuickBase app automatically. To help solve this problem I wrote a QuickBase REST API Starter Development Kit for PHP that we currently use in a plugin for talking to QuickBase! I wanted to share this with anyone else who might need/want it for their needs. Here is the link to the GitHub Repo: GitHub - josephharburg/QuickBase-REST-API-PHP-SDK GitHub remove preview GitHub - josephharburg/QuickBase-REST-API-PHP-SDK: This is a simple class to help get started using the QuickBase REST API in PHP. This is a simple class to be used to access the REST API that QuickBase offers for PHP. This starter development kit does not do all the work for you, however, it does give you a good leg up when trying to access the QuickBase REST API in PHP. View this on GitHub > Happy Coding! ------------------------------ Joseph Harburg ------------------------------
REST API Updating a Key Field Value
Hi, I am using this REST API for updates: https://developer.quickbase.com/operation/upsert The issue I am trying to resolve is when I update a table with a non Record ID as the key field I am getting this error message: Unknown error: You cannot include the record ID if it is not the key field. Example: An Employee table with an "Employee ID" as the key field. If there is an error with the Employee ID that needs correction, how do I use the REST API to update the key field Employee ID if I cannot use the Record ID via the API?Restful API / Update record
I am attempting to update a record. The guide groups Insert/update in the same example. Updating a record requires the field key. Yet, when I'm including the value to update the record, the error message states I don't have permission to ADD records. See below: field 19 has the key number and field 656 is the column being updated. Am I missing something? var headers = { 'QB-Realm-Hostname': 'shumasports.quickbase.com', 'User-Agent': 'joeinatlanta', 'Authorization': 'QB-USER-TOKEN byud27_kxv6_dx6c7ygcyti5cizy2spyp22vy', 'Content-Type': 'application/json' }; var body = {"to":"bnsjwj798","data":[{"19":{"value":44981},"656":{"value":1234567890}}],"fieldsToReturn":[656]}; $.ajax({ url: 'https://api.quickbase.com/v1/records', method: 'POST', headers: headers, data: JSON.stringify(body), success: function(result) { console.log(JSON.stringify(result)); } }) ------------------------------ Joe Lugo ------------------------------