Recent Discussions
Image display
Is there a way to embed an image in a new form? Use case: Need to have a different image displayed every time I add a new form. Not file attachment. Ideally, be able to pick the image from a file explorer or paste the image on the new form. I have a "Parts" table and want to display the image of the part. ------------------------------ ed cooper ------------------------------0likes1CommentService Worker
I am working on implementing changes with Service Workers. I am following the series of posts from Dan Diebolt, Service Worker Travel Logs, and it is making sense. The one part I am stuck on is in the last one;https://community.quickbase.com/quickbase/topics/service-worker-travel-log-day-13, specifically implementing the cheerio.js library. Do I need to bring over every file in the GitHub page, or is there a way to simply reference them all at once?1like7CommentsChicken 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. ------------------------------11likes13CommentsHappy Retirement Kirk Trachy!
Hello Quickbase community! We wanted to take a moment to recognize a very important member of our Quickbase community. After 16 years of helping hundreds of people leverage Quickbase to solve a host of business problems, Kirk "Magic Buttons" Trachy is retiring at the end of the year. For those of you that have met Kirk, his passion and enthusiasm for our product, and our customers, is instantly palpable. If you have not met Kirk and you want to better understand the tremendous impact he has had, there are two places you should look. The first place is the app exchange. If you search Kirk's name, you'll find 50 applications that have been downloaded over 40 thousand times. Thanks to some work by Ellie Ellerman, we know that there are over 1700 currently successful apps in our community thanks to those templates. The second place to look is YouTube. Over the past several years, Kirk has submitted dozens, if not hundreds, of videos walking builders through a wide array of building tip & tricks to solve their unique business challenges. Kirk has played an oversized role in our community. If Kirk has helped you become a better QB builder, please share your thoughts/well wishes here in the Kirk Trachy Retirement Guest Book app that members of our awesome partner community put together. If you have ~8 minutes to spare, hear from some of Kirk's peersin this awesome tribute video Thank you! ------------------------------ Freddie Sabbs fsabbs@quickbase.com ------------------------------2likes0CommentsDate Formatting
Hello: I am just trying to change date formats in Quickbase. Normally I would have: 07-22-2020 Would like to change the hyphens to backslash: 07/22/2020 I am outputting a CSV file for import into an accounting program. Accounting program does not recognize hyphens. I am hoping this is a simple fix. Thank you, Dirk ------------------------------ Dirk Ruana ------------------------------Formula Queries Blog
For anyone considering Formula Queries, you should start your FQ journey by reading this blog post by Brian Cafferelli: https://community.quickbase.com/blogs/brian-cafferelli1/2021/10/14/formula-queries-are-now-generally-available ------------------------------ Ben Simon bsimon@quickbase.com Do you have Feedback on how to make Qrew Discussions a better experience? Let's chat! https://calendly.com/bsimon-2 ------------------------------2likes0CommentsMilitary time conversion
Trying to find a way to solve this: I am doing time and date tracking for a support app. I have a date field. I also have a start time and end time fields where I would like to user military time: Date:_05/12/2021____ Start Time:__1000 End Time: ____1130 I would like to convert the military times in the Start Time and End Time fields and subtract the Start Time from the End Time so the value in Total time needs to be in hours and minutes Total Time: __1.5 hours Help!! ------------------------------ ed cooper ------------------------------0likes6CommentsHow to get a application token?
I just took over the QuickBase Operation for our company. And I can find anything that allows me to create/review API token? Anyone can give me an idea where to look for it? ------------------------------ Andreas Nagel Senior Software Developer www.KEH.com ------------------------------Rich Text - Formula Fields are pretty nice.
This is fantastic! That underlined bit down there all appears to be functional. Note the OpenAsPopup must be first, if SaveBeforeNavigating precedes, it doesn't work. Rich Text - Formula field example: var text btnName = "+ Child Records"; var text url = URLRoot() & "db/" & Dbid() & "?a=showpage&pageID=34#" &[Record ID#]&"&"&[Related Records]); var text style = [styleAdd]; var text title = "Add Record Button"; //*****DO NOT EDIT BELOW THIS LINE***** //HTML "<a class='Vibrant Success OpenAsPopup' data-height=600 data-width=600 class='SaveBeforeNavigating' data-refresh=true title=\"" & $title & "\"style =\"" & $style & "\"" & $target & "href=" & $url & ">" & $btnName & "</a>" [styleAdd] is a Quickbase variable in the App Properties so you can style all the buttons in all the tables in all the forms once. Here's the variable: display: block; width: 130px; text-decoration: none; text-align: center; padding: 8px; font-size: 12px; color: #ffffff; border-width: 1px; border-color: #777777; border-style: none; border-radius: 3px; background-color: #6BBD57; It makes a green button just like a QB button but in a form. Imagine a Button on a form, Form properties have the "alternate name" = blank. Fields on the form can be changed before clicking the button (no more Save & Keep Working!!! No more losing changes!!!). When the button is clicked, the code page loads in a 600X600 popup window and the code runs (not in a browser tab!!!). When the code is complete, a JavaScript alert in the code page prompts the User the code is done and closes the popup window. When the popup window closes the Form saves and reloads!!! Example: A checklist table with a generic checklist. A new record that needs a checklist. The checklist added to the new record is related to the record and therefore its own checklist. The checklist is not "related" to the generic checklist table. The benefit of this process means changes to the record-checklist will not affect the generic checklist records nor other checklist records. All I need to figure out now is how to style the js alert() so it is consistent with qb alerts. Thanks Quickbase! These class changes have given Users much better flow to their daily processes. ------------------------------ Jim Harrison transparency = knowledge + understanding : The Scrum Dudes ------------------------------2likes0Comments