Get Expert Help

Quick Base Junkie Blog

Short videos and posts to skyrocket your Quickbase skills!

Get tips in your inbox

Join the Quick Base Junkie Community email list!

My #1 Formula Shortcut for Quickbase

tips & tricks Aug 17, 2023

When I first saw this tip I couldn't believe my eyes πŸ‘€

It has literally changed the way I write formulas and in the process made me much more efficient!

Using a simple Ctrl + click in multiple locations, I can place multiple instances of my cursor throughout the formula. 😲

(Mac users will use ⌘ + click)

Now, anywhere I have repeating text I can simultaneously type, edit, or delete in mass. πŸ’£πŸ’₯

In the video, I show how this works wonders on long formulas.

I especially find it helpful when I need to comment out (or un-comment) a large piece of the formula.

I hope you find this formula as useful as I have and kudos to Ryan Murray @ Quickbase for originally sharing this tip!

Ready to master text formulas in Quickbase? πŸ€”

Get 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 (Functions 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.

Start Mastering Text Formulas Now


What Quickbase Developers Say About Mastering the Text Formula


Clear and detailed. Your course was fantastic.
—Mike B.



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.



Great knowledge, will definitely refer back to these formula examples.
—Rob P.



Very in depth!
—Brenda Z.



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.



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.



Great refresher course and check out the use case example section
—Robertson R.



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.

Start Mastering Text Formulas Now