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. ?57Views0likes5CommentsHow 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 ------------------------------18Views0likes3CommentsCopy Master & Detail Records bottun
Hi Everyone, I'm pretty new to QuickBase so I 'm not sure if this question is addressed somewhere else or not. I created a button to copy a record and it looks like the formula is working fine. I'm just wondering if there is any way to modify this formula? Basically, I would like to change the value of a specific field(the field is a Text - Multiple Choice) when I copy the record. Copy Formula: "javascript:void(copyMasterDetailButtonHandler('&relfids=61,14©Fid=6&destrid=0&sourcerid=" & [Opportunity #] & "', 'br74dayx8'))" ------------------------------ Michael Naser ------------------------------7Views0likes1CommentUpdate 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 ------------------------------6Views0likes3CommentsHow to extract metadata
Hoping can someone can help me. I need a way of extracting/exporting all field information from a table. The metadata not the actual data - does anyone know if this is possible? Many thanks in advance ------------------------------ Paul Conway ------------------------------6Views0likes4Comments2022 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 ------------------------------4Views1like4CommentsRestful 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 ------------------------------4Views0likes2Comments