Looking for simplest example to access quickbase using python
Can someone point me to examples that show how a quickbase/db can be accessed from the command line/using python -? We would like to access, add, delete, change records and create reports - and in addition to the GUI provided, do such using CLI tools and python (saw pybase on github, am having some difficulty with it - unless someone can provide a complete example -?)
URL formula to edit a record and ""refresh the page
I regularly use little API URL formula buttons like this one. var text $CopyStatustoPreviousStatus = blah blah blah ......; $CopyStatustoPreviousStatus & "&rdr=" & URLEncode($ReDisplayReport) That works well when I have a button dedicated to either refreshing the record I am sitting on or refreshing a particular report. I also use this great technique a lot to not refresh the report (so the user does not lose their place in the report or does not lose their Dynamic filter selections. var text URL= blah blah blah ....; "javascript:" & "$.get('" & $URL & "',function(){" & "$.jGrowl('email Triggered to Prospect', {life: 5000});" & "});" & "void(0);" But I would love to know how to make a button which will do some blah blah blah stuff and then refresh the screen - that way I could have the same button be used on any report and any record. Ideally it would reload the screen and preserve the user's Dynamic filter selections if they were on a report. If there a way to modify the code above to incorprate this concept &"javascript:location.reload(true);" and not do the growl pop up. ie I'm looking for a button to be able to execute a URL formula which would say edit a record and then refresh whatever screen the user is on. In that situation with a refresh, typically the user's feedback that the button click "took" will be that the report refreshed or the record refreshed, so we don't need or want that jgrowl pop up.Close a pop up form after a button is clicked on the form
I have a button that sits on a report that is on a user page that creates pop up to a special form that also has a button that that acts on a checkbox and then refreshes the page. Here is my formula that sits on the pop up form: var text Update = URLRoot() &"db/" & Dbid() & "?act=API_EditRecord"& "&rid=" & [Record ID#] & "&_fid_1046=1"; var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); If([Ready for Dispositions]=false,$Update & "&rdr=" & URLEncode($RefreshPage)) What do I need to add to my formula to close the pop up after the button is clicked? ------------------------------ George Bramhall ------------------------------
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 ------------------------------
Lookup and fill field values based on the content of another table
I have two tables: Table A holds records for daily delivery routes, two of its fields are the [Driver Name] and [Van ID]. Table B holds records of every stop completed on all daily routes, it also has the fields [Driver Name] and [Van ID]. The stop records in Table B are imported via an API call to a platform which records GPS tracking data for each van. The [Van ID] is obtained with the call, but the [Driver Name] cannot be. What I want to do is for every record in Table B, where the [Van ID] = "123", for example, I want to lookup in Table A which delivery route had [Van ID] = "123" and find the associated driver name, and show it in the Table B record(s). Has anyone had any experience with a problem like this? Thanks
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. ?
API Edit Record, Mailto, and a rdr or nexturl?
Hi everyone, I am trying to create a button via rich text field that will process an API call to update a record, open an email via a mailto, and redirect back to the record page I was on in one click. I understand there is no way to confirm the email was sent, but opening in the browser will be okay by me. Here is the code I have, which shows a white blank page after running. How do I continue the rdr back to the url? You can see I commented out code as it was not working: var text baseurl = URLRoot() & "db/"& Dbid(); var text purchTbl = $baseurl & [_DBID_PURCHASE_ORDERS]; var text editRecord = "?a=API_EditRecord&apptoken=" & [EliteApptoken] & "&rid=" & [Record ID#]; var text LABEL = "Executive Approval"; var text decoration = "text-decoration: none;"; var text bgColor = "background: #0044cc;"; var text txtColor = "color: white;"; var text txtAlign = "text-align: center;"; var text txtShadow = "text-shadow: none;"; var text border = "border-radius: 5px;"; var text padding = "padding: 8px 20px;"; var text display = "display: inline-block;"; var text font = "font: normal 700 24px/1 'Calibri', sans-serif;"; var text styleOptns = List("", $decoration, $bgColor, $txtColor, $txtAlign, $txtShadow, $border, $padding, $display, $font); var text mailto = "mailto:" & [Manufacturer - PO Submission Email] & "?subject=Purchase Order&body=Please review the attached Purchase Order and confirm receipt."; If([Old PO], "", If(IsNull([Executive Review On]) and IsNull([Project Review On]), "<span style= 'font-family:Calibri;color:#57a3f0;font-size:14px'><Strong>Requires Executive Approval</Strong><br /></span>", "<div><a style='" & $styleOptns & "' class='Vibrant' href='" & $baseURL & $editRecord & "&_fid_40=" & Today() & "&rdr=" & URLEncode($mailto) & //URLEncode("&rdr=" & //URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>Submit PO</a></div>"))//) ------------------------------ Ivan Weiss ------------------------------
Custom Save and Close button
Hello everyone, This is probably a super simple solution but for the life of me I have not been able to get it to work. I am trying to create a custom button that simply saves the record on a form that has both the parent and the child records in edit mode. Example: A parent record form has an embedded grid of related child records. When the parent record is in edit mode, the grid of child records is editable, so that the user can add or modify the related child records. At this point, the parent record has already been saved, so the record ID of the parent already exists. All I want my button to do is to save any changes made to both/either the parent or the child records. I want this button to work exactly like Quickbase's native "save & close" button. Thanks in advance for your help! ------------------------------ Juan Solorio ------------------------------
Buttons, Buttons, Buttons - (new code for all!)
Hello all, Sorry I haven't gotten around to putting out some nice code goodies, but today is a new day full of buttons for you. So here you go! This basic gray button saves your work and then sends you to a code page. - It is good for saving and then a thank you page or you can alter it to go to another form. Just plop it in a Rich TextFormula Field and you are ready to go. Pretty slick. "<a class='Vibrant Snowy SaveBeforeNavigating' href='https://mysite.quickbase.com/db/tableIDhere?a=dbpage&pageID=12&ifv=10'>Save & Logout</a>" This next little bit of code really can be used for any link or button, and is a life saver for those of us dealing with the EOTI role. This is a special encoding that QB can understand. I have it here encoding the Record ID#, but you can use it for any number. ENCODING: &r=" &QB32Encode([Record ID#]) URLRoot() & "db/" & [_dbid_table] & "?a=dr&r=" & QB32Encode( [Record ID#]) Have you ever just wanted to click a button and save something as a csv? Yeah, me too. So I did. This one can take a bit of set up (or not) depending on if you want to download a filtered report or not. First I make a report (qid=59 in this case), then I make a bunch of "ask the user" filters (V0, V1, V2,...). This would be a filter where you would say, filter by Shirt Size and instead of putting 'equals Red' in the report, you would put 'equals <ask the user>'. Then you would put whatever you were wanting to filter for the report into the code below. This is great for dynamic reports. But back to the CSV. As you can see on the end, there is '&options=csv'. It really is that easy. Just plop this is a URL Formula Field and make yourself a button. https://myebsite.quickbase.com/db/tableID?a=API_GenResultsTable&qid=59&nv=3&v0=MyFirstFilter&v1=MyNextFilter&v2=MyOtherFilter&options=csv Looking for an alternative to using the Record ID# in your links / buttons. Yeah, who wants to use the Record ID# when your key field is your email? I sure don't, and I'm just lazy enough to make it work. The key is the 'Key' field. Below I have an example of a button that saves what the applicant is working on in one form and then navigates them to edit their parent record by looking up their email. In the parent table, the Key is Applicant Email, so it can use the Applicant Email Address from the child table (the application that they are working on) to find the parent profile record. Just throw this button into a Rich Text Field and you're done. "<a class='Vibrant Success SaveBeforeNavigating' href='https://mywebsite.quickbase.com/db/tableID?a=er&key="&URLEncode([Applicant Email Address*])&"&ifv=10'>Edit Applicant Profile</a>" And last of all, a nice list of the "Vibrant" button set: List(" ", "<a class='Vibrant'>Vibrant</a>", // regular grey button "<a class='Vibrant Alert'>Vibrant Alert</a>", // yellowish "<a class='Vibrant Danger'>Vibrant Danger</a>", // red "<a class='Vibrant Primary'>Vibrant Primary</a>", // blue "<a class='Vibrant Snowy'>Vibrant Snowy</a>", // white "<a class='Vibrant Success'>Vibrant Success</a>" // also blue, but they clain green ) Super Secret Bonus Code: Gradient Background (can be used in buttons and code pages!) background-image: linear-gradient(220deg, #1e6fb7 50%, #5086b5 80%); ------------------------------ QuickBase Girl ------------------------------
