Example of SaveBeforeNavigating
Just came by to say it's verking! I am filled with so many happy's. "Builders can now use a new CSS class ( SaveBeforeNavigating ) inside of a formula-rich text field so that Quickbase saves the record before navigating when this setting is used. Note that only one of the above workflow classes is supported per formula-rich text." Example code of a button: var text btnName = If(Contains([Egnyte_Link_Text],""),"", If([Email Payroll Trigger],"Email Sent","Send Dispatch to Payroll")); //URL var text urlOne = If(Contains([Egnyte_Link_Text],""),"",If([Email Payroll Trigger], URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & URLEncode ([Record ID#]) & "&apptoken=&_fid_369=0&_fid_370=\"\"" & "&z=" & Rurl(), URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & URLEncode ([Record ID#]) & "&apptoken=&_fid_369=1&_fid_370=" & Today() & "&z=" & Rurl())); var text urlTwo = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & URLEncode([Record ID#]); var text url = $urlOne & "&rdr=" & URLEncode($urlTwo); //Style var text style = If(Contains([Egnyte_Link_Text],""),[styleGrey], If([Email Payroll Trigger], [styleGrey],[styleEdit])); //Target var bool popup = false; var text target = If($popup = true, "target = _Blank ", ""); var text title = "Click button to send Dispatch to Payroll"; //*****DO NOT EDIT BELOW THIS LINE***** //HTML "<a class='SaveBeforeNavigating' title=\"" & $title & "\"style =\"" & $style & "\"" & $target & "href=" & $url & ">" & $btnName & "</a>" //Syntax end ------------------------------ Jim Harrison transparency = knowledge + understanding : The Scrum Dudes ------------------------------4Views1like0CommentsHappy 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 ------------------------------3Views2likes0CommentsCalendar Report
Hello, I need help with quickbase calendar report. I currently have a field called start date which has list of companies. I have a another field called frequency which is multiple choice field consisting of daily weekly semi-monthly and monthly. I want to have calendar show the records which falls in the freqency range from start date. Can it be achieved in quickbase? ------------------------------ XYZ XYZ ------------------------------3Views0likes4CommentsConnecting Quickbase to AWS for Sentiment Analysis
Quickbase is uniquely positioned to solve numerous business problems because of both the product's incredible flexibility and the different approach to how people build applications on the platform. The problem solvers who use the tool can resolve critical business challenges themselves in days and even hours on a system that IT trusts and can govern at enterprise-scale. Although powerful in business users' hands, the technically inclined can elevate Quickbase to new heights by integrating it with other systems through extension points such as Pipelines, Quickbase's native integration platform. Public cloud providers like Amazon Web Services provide many building block services that go together with Quickbase like peanut butter and jelly, and I want to introduce a sentiment analysis capability for Quickbase using Pipelines and AWS as a working example of this power. The Amazon piece is available at https://github.com/cpliakas/quickbase-sentiment-analysis, and developers can replicate the pattern for other AWS services as well. As context, Quickbase applications often capture data at the edge of the business. The more data that is captured, the more important it is to automate data analysis to extract insights from it. For example, let's say you want to crowd-source inspection of inventory, products, etc. The goal is for employees to snap pictures and submit comments when they happen to notice something in the field, such as an example of a great product display or a misplaced item. Within minutes, you can create a Quickbase application that is mobile-ready and able to be used in the field. A welcomed problem is when the application becomes widely used across the organization, and manual analysis of the data becomes impractical. One way to start categorizing the data is through sentiment analysis of the comments to sort the feedback into positive, negative, and neutral submissions to determine which ones to act on first. This situation is where our example comes into play. Amazon has a service called Comprehend that provides sentiment analysis. At first glance, the integration appears to be dead-simple. However, many hidden complexities around authentication and infrastructure configuration take time to figure out. The project at https://github.com/cpliakas/quickbase-sentiment-analysis provides a one-click install of the Amazon piece of the puzzle through theServerless Application Repository that has Quickbase assumptions which make it really easy to securely integrate with Quickbase through Pipelines. The video below walks through an end-to-end setup so that you can start experimenting with the capability now. The https://github.com/cpliakas/quickbase-sentiment-analysis project is released under the permissive open-source MIT license. You are free to use and copy the tool and apply the patterns in whatever manner you wish, including commercial applications where people pay for your service. I hope you find it useful, and I look forward to learning about where the tool and techniques are providing value to your Quickbase applications. ------------------------------ Chris Pliakas ------------------------------2Views1like0CommentsMobile Tools for Quickbase
Quickbase is a low code platform, it is great for businesses and people with low coding experience, but its limited integration with the most used device in the world is what we are here to solve. We at ArkOne Software introduce "Mobile Tools for Quickbase", a mobile app that works on Androids and iPhones'. It works with your existing Quickbase setup, so just configure your app and make your Quickbase life easier. Mobile Tools for Quickbase Mobile Tools for Quickbase uses the ever-powerful Quickbase API to work. All the heavy lifting is done by the app while all you have to do is sit back and let it work. A quick overview of the app:- Video - Mobile Tools for Quickbase We provide a range of tools that integrates your phone and your Quickbase database. Some of the tools that we offer are:- -File Tool Download/Upload files to and from your phone's storage -Contacts Tool Upload phone contacts to your QuickBase table from your phone and also add a new contact from your QuickBase table to your phone. -Data Change Alert Tool Get a real-time notification on your phone when your record changes in the Quickbase table. -Event Scheduler Tool Check your schedules from Quickbase or create a new event record. Quickly add events into your iOS/Android calendar. It's an all-in-one Simple Schedular For Quickbase. -Image Resizer Tool With this tool, you can quickly and conveniently resize, scale, screw and rotate images. The edited image gets saved into the same record. No hassle! -Data Grid Editor Tool This tool can help you do those quick edits in multiple records from a page view and save them all at once on the go. -Signature Tool This tool can help you to capture signatures on your phone or tablet. The electronically signed image file is then automatically uploaded into the file field of the record. More tools are being built and existing tools are being refined as per user feedback. No signup is required to use this tool so give this tool a go and see how it enhances your Quickbase experience. If you want to contact us or have any feedback or suggestions, please visit Contact ArkOne Software ------------------------------ Arkone Software ArkOne Software ------------------------------2Views0likes0CommentsRich 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 ------------------------------2Views2likes0CommentsWell designed Example Forms
I would like to see some other users that have well designed forms. We have a number of what we think are good forms but would like to see some forms that are being used by other companies. The application does not matter but we use QuickBase to manage our real estate, Properties/Buildings/Leases/Projects. Rob ------------------------------ Rob Peterson ------------------------------2Views0likes0CommentsChicken 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. ------------------------------2Views11likes13CommentsQuick Base Thanksgiving (less stuffing more Apps)
With Thanksgiving fast approaching it is that time of the year (unbelievably, I know) where we reflect on things we are grateful for. With that in mind, I wanted to throw out a seasonal off-topic thread on things you are grateful for this year in your professional life and growth. It would be great to hear some of the things you are grateful for and what has helped to push you forward in the last year. Not sure what to talk about but want to participate? I have a few suggested questions below, pick one or a few to share. 1.What is one piece of professional/workplace advice that you are most grateful to have received 2. What is one Quick Base feature that you are grateful for and what did it change for you? 3. In the last year what is a challenge that you tackled that helped grow your skills and pushed you out of your comfort zone? How did it push your skills to grow? 4. What is one time saving trick you have picked up this year that has proven itself to be a blessing? Have an App-y Thanksgiving! ------------------------------ Evan Martinez Community Marketing Manager Quick Base ------------------------------1View0likes12Comments