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 ------------------------------45Views0likes2Comments2022 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 ------------------------------31Views1like4CommentsHow 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 ------------------------------100Views0likes3CommentsReoccuring Tasks
Hello, Below is a YouTube of something I want to do so badly for one of my tables, and I cannot figure out how to configure it to my tables. The examples he provided are tailored to his table. Please help! I have reached out to QuickBase support as well, and they've been trying to do something for over a month, it is something I need sooner than later, and this is exactly the way I want it, I just can't read the code well enough. SOS? https://www.youtube.com/watch?v=OtE_j7kPJK0 ------------------------------ Newman, Savi ------------------------------6Views0likes0CommentsQuickbase 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. ?169Views0likes5CommentsHow 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 ------------------------------37Views0likes4CommentsBased on the number of units in a project, create new property records?
Hi, When I type it out, it seems simple but I can't figure it out. Background: I work for a real estate company where we often take on projects that have multiple units on the same area of land- think of townhomes. If I'm in a project record with "Units= X", I'd like to create X number of new property records in the properties table. I'm trying to achieve this with a pipeline, but I can't figure out how to iterate through a loop X number of times based on the value of a record. Please help! Thank you in advance! ------------------------------ Karah Weber ------------------------------13Views0likes1CommentCopy 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 ------------------------------28Views0likes1CommentURL field that's clickable / defaulted for all and new records
Hello, I feel like this is so simple but I've attempted a few different ways to do this with no luck. Every time I input a new record into my projects table, I have to confirm an agency associated with it. We finally found a source we want to use with a specific URL link. I've attempted to generate a new URL field and place the link in the default value for us to select it each time we generate a new record and it doesn't show. I've tried the formula - URL as I have buttons that do other internal actions and figured if I input the URL and selected open new window this would logically make sense but my input is wrong. I'm open to any situation, however the goal is the same URL is applied to the field on any new record for us to select when we are creating a new record. If I can make it a button that's selectable I'd love that as well, but if it's not possible I'm more than happy with a consistent link that appears for me on each new record. Thank You for your help! ------------------------------ Anthony Wong ------------------------------10Views0likes1Comment