Is it possible to create a ""Save and Keep Working"" button from a formula URL field?
I realize the "Save and Keep Working" button was introduced by Quickbase, but I am wanting to add it somewhere in the middle of my form. I've seen posts relating to this kind of thing, but all of theme were published prior to the introduction of the "Save and Keep Working Button" and I can't seem to get any of them to work. Any thoughts?
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 -?)
Chicken Tracking with QB
Here's my latest cause for Quick Base celebration: A while back I made a Quick Base app for tracking my flock of chickens and supply inventory, but just incorporated RFID scanning to help move toward automatically tracking egg production instead of manually tapping URL formula buttons. Very much still a work in progress, but here's what it does so far and how it works: The app keeps records of what chickens are in the flock, egg production, store health records, supply purchasing/use, and a journal to write entries about any or all of the chickens. One night I was browsing my favorite overseas merchant website and came across these leg bands for fowl that contain an RFID chip. They were about $.27 a piece, so I bought a bunch, and a cheap USB RFID reader too. I created a table of all of the RFID tags, and a table for scanner entries, and linked each chicken to an RFID number, so that when one was scanned the entries table would "know" who the chicken was. Then I needed the scanner to be in a stationary place ready to scan anytime, so I wrote a little Python script that sits and waits for a scan, and when it detects one creates a record in the entries table using the Quick Base API. I decided to put the scanner in the nest box to find out who was laying eggs and when. It's also a confined space where I thought I'd have the most luck with the RFID system, which is the low-frequency passive type (chosen because they're cheap and don't require batteries or charging. The trade off, however, is that they only get scanned when they are close enough to receive power from the scanner). After hiding the scanner under some straw on the side of the nest near where the banded leg would be, the Raspberry Pi was put outside of the nest on a nearby shelf. With everything set up, connected to the network and seemingly working, it was time to put the bands on the chickens: Over the next few days of anxiously awaiting email notifications of scans, I finally got about 40 one morning over the course of about 45 minutes, all from the same chicken. I've had some luck so far, but have been looking into a more powerful scanner that would ensure scans without the RFID chip needing to be so close to the scanner. (Since putting in the scanner I've also found a couple of bushes the chickens have been laying eggs under since they have the run of the yard in summer, but with winter coming they should be laying more inside). I'd also like to add more scanners in various locations, but that may depend on what can be done to find a scanner that could read at a longer distance. I also need to find a better way to display some of this data, especially if its coming from multiple scanners. I'm thinking a summary type table that would group by location and calculate duration to show how long a chicken was in a given spot over the course of a day. A way to detect if an egg is actually laid, and automatically log that in the egg table for the correct chicken is also a future addition once the best way to do that is figured out. Ultimately, it'd be cool to have scanners that could also track various spots to get an idea of how they spend their days, and know when they're all inside for the evening and automatically close the coop door for the night. If anyone has any ideas about any of this, or experience working with RFID or Raspberry Pis and Quick Base, I'd love to hear about it! ------------------------------ steve. ------------------------------
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 ------------------------------
Save button with a redirect
I haven't found a thread yet with a solution that is working with me so, I am trying to to make a button that saves and redirects. Currently I am trying <div class='Vibrant Success' onclick='RedirectURL.value=myurlhere;editform.rl.value="";DoSave();'>Save</div> I got my current setup from this thread https://community.quickbase.com/quickbase/topics/how-can-i-save-and-redirect-to-a-home-page This thread is the closest thing to what I am looking for. I would like to be able to save a form and then be redirected to a different table and its default report. Is there an easier solution?
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. ?
QuickBooks Online APIs & oauth
Hey all, I'm in the very beginning stages of setting up a couple of API calls (send via "make request" step in pipelines) to QuickBooks Online. I have searched for an example of a successful implementation somewhere in the forums but can't find one. The article on Base-Books pipelines makes a reference at the very end to more information regarding using API calls to add sub-customers and rates, but I haven't been able to find it. I've got all the QBO-side API documentation, but I'm a bit stuck and would just love to look through an actual functional API call. Does anyone have a good example they'd be willing to share with me, or know of an app with an example in the exchange maybe? Thank you! #quickbooks #APIsandcustomcode #Pipelines #oauth2 ------------------------------ Elena Larrabee ------------------------------
