What can you do with text formulas? ⭐️ Extract characters from a text string leaving just the part that you need ⤏⤏⤏ Functions such as: Left, Right, Mid, NotLeft, NotRight, and Part ⭐️ Combine text from fields or text strings to produce lists, summaries, and more ⤏⤏⤏ Function and operators such as: "&", List, and Split ⭐️ Modify and manipulate text to get it into...

Are you guilty of downloading the Action Button Toolbox, but not using it? You could blame it on the dog (I know first hand these furry distractions are no joke). 🐶 Or, follow along and add one or more of these three action buttons today.   Button #1 – Go Home On any frequently used table add a button to ‘save & go home’. Normally...

Are you using URL & Rich Text Formula fields? In the past, some of these features were only possible using Javascript. Now, they're built into the field settings! In this video, I demonstrate how to use 3 AMAZING new URL & button features. What are the new URL & Button features? Open target in popup (URL & URL Formulas) Embed as iframe on forms (URL...

Why use HTML in Quickbase formulas? If you're looking for a way to add extra function and style to your Quickbase apps, what you're actually looking for is HTML formulas. HTML formulas combine the power of formula functions with the visual appeal of HTML (and CSS) resulting in imgmore engaging and professional looking applications. What can you do with HTML Formulas? Combine formula functions with HTML to dynamically...

 What is Jinja? Jinja is a templating language for Python programming. And if you're already confused... that's okay. In the simplest terms, Jinja is the language we use to write powerful formulas inside of our Quickbase pipelines.  Why use Jinja in your Pipelines? Jinja allows you to write formulas within your pipeline, transforming the data as needed between two sources. This means fewer 'helper' fields within...

If you have parent records with LOTS of children add a search box to the form to make finding the 'right' record easy! It can be frustrating (and eye-straining) to sift through page after page of information looking for a specific record. Adding search functionality on a form to quickly search & filter a report of child records is easier than it sounds. In this...

Action buttons allow you to optimize your workflows, cutting out clicks and putting information at the point of need! In this tutorial, we'll build three different Action Buttons and I’ll share a toolbox that will enable you to build countless others to suit your needs. 1. Save & Go Home 2. Open Documents in a New Tab 3. Open the Latest Child Record   Along with building...

If you missed Quickbase's Empower Conference last week, that's okay. This year's event was moved to 100% virtual, so you can still attend virtually all the sessions. But, with over 40 hours of content available... where do you even start! 😱 As an experienced builder and Quickbase consultant, the 3 technology changes that really wowed me and got the creative juices flowing were: Pipelines New...

There are so many amazing ways to use formulas in your Quickbase apps that extend beyond your basic arithmetic... way beyond. Here are some of my favorites! Adding Color Want to make your text stand out? Add color! [6 mins]   Adding Images Use icons to draw focus and drive action [11 mins] How to add images for picture-perfect reports & forms [15 mins]  ...

What is a database without data integrity! Ensure the quality of data entered into your Quickbase apps using Custom Data Rules. These rules apply no matter what form is used or even if Grid Edit is used. In this tutorial, I walk you step-by-step how to set up custom data rules for any table in Quickbase. I break down the formula details for: A single...

Navigate through your Quickbase with ease by adding "go to page" buttons on your forms using the URL formula field. For example, the button can easily allow a user to "go to"... The current table home page A different table home page The app home page A code page In the Secrets of API Buttons for Quickbase course, I teach you, step-by-step, how to create these...

Adding notes inside your Quickbase formulas can save you huge amounts of time and frustration in the future! Notes within your formula fields will allow you to no only describe what the formula does, but also allow you to call out any special information such as where information is coming from or how it's intended to be used. A note can consist of whatever information...