If you have an existing account, please login prior to purchasing.
Level: Beginner/Intermediate
Prerequisite: Basic understanding of Quickbase
Video Length: 2.75 hrs
Est. Completion Time: 1.5 days (to allow for practicing & following examples)
THE MOST comprehensive course on Quickbase text formulas.
Learn to confidently use text functions that:
- 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 the format you need (Functions such as: SearchAndReplace, PadLeft, PadRight, Upper, Lower, ToText, and ToFormattedText)
- Evaluate the contents of a text field against specific conditions to arrive at a true/false result (Functions and operators such as: "=", "!=", "<>", Contains, Begins, Ends, IsNull, true, false, and not)
But wait, there's MORE!
- Use logic to determine if a specific criteria is met AND return a specific result depending on if the criteria was or was not met (Functions and operators such as: Case, If, Min, Max, And, and Or)
- Learn methods and strategies to combine functions to produce incredible results!
- Get tips & shortcuts to help you build, organize, and troubleshoot your formulas.
What you'll get:
- Step-by-step videos breaking down 30+ text formula functions
- Multiple use case videos demonstrating how to combine text functions and leverage them in your apps
- Bonus videos with more text formula uses that extend the functions beyond basic fields
- A cheat sheet file of all the text formulas for easy reference
- Swipe files of the exact formulas used in each of the use cases and bonus videos that you can copy from anytime
- 12 formula shortcuts to help you manage your formulas
- A behind the scenes look at my Formula Lab app
Important Notes:
This course does not include the use of Rich Text formula fields or how to use HTML in formulas. For that, I recommend the HTML Formula Crash Course.
The videos in this course utilize the classic Quickbase interface (pre 2023) which does not include the newer navigation, forms, or dashboards. These new interface features do not impact the central topic of this course and can be "turned off" to facilitate following along if necessary.
What Builders Are Saying:
★★★★★
Mastering the Text Formula
Clear and detailed. Your course was fantastic.
—Mike B.
★★★★★
Mastering the Text Formula
This is a great overview of text formulas. If you had done some work with text formulas, this may not be anything very new, but, you can always take little nuggets of tricks that you can use. Still worth going through it, even at 1.5x speed :)
—George K.
★★★★★
Mastering the Text Formula
Great knowledge, will definately refer back to these formula examples.
—Rob P.
★★★★★
Mastering the Text Formula
Sharon completely explains and uses functions throughout this class. It is amazing how much you will learn to expand the functionality of your quickbase applications!
—Myra C.
★★★★★
Mastering the Text Formula
Excellent course! I was unsure about how to successfully use text formulas, but now I am confident in my ability to manage and enhance my Quickbase Apps as needed.
—Allan H.
★★★★★
Mastering the Text Formula
This was a super helpful easy to follow course. I especially appreciate the real world examples after learning the formulas to see how to apply them.
—Kristina H.