12 Quickbase Tips and Tricks

[vc_row][vc_column][stm_post_details css=”.vc_custom_1500063678792{margin-bottom: 0px !important;padding-bottom: 0px !important;}”][stm_post_bottom][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_empty_space][vc_column_text]You know that Quickbase can streamline your processes, eliminate repetitive tasks, and boost productivity, but mastering this powerful platform takes time and practice. Whether you’re a new Quickbase user or a longtime fan, chances are the following tips will help you take your skills to the next level. How many of these Quickbase tricks do you use?[/vc_column_text][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”1. Add comments to fields, especially formula fields” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]Quickbase recently introduced the Comments tab in field settings. Unless it’s obvious, at Watkyn we always add a comment stating who created the field, on what date, and what the field is meant to be used for.

In a formula field, a double slash (//) is used to indicate a comment. Anything that comes after // on a line will be ignored by Quickbase. Formula comments can be helpful to anyone who needs to follow the logic of your formula.[/vc_column_text][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”2. Organize your reports into meaningful groups” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]When you expand the Reports & Charts area on any table homepage, you’ll see reports listed by name under the heading “Common.” You may not have noticed the little gear icon that says Organize. If you click here, you can then drag reports to create a new group, which can be collapsed or expanded to make it easier to find the report you or other users need. If you’ve saved any personal reports from that table, you’ll also see a report group labeled “Mine.”[/vc_column_text][vc_single_image image=”2703″ img_size=”full”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”3. Try out the Quickbase Performance Bar” use_theme_fonts=”yes” el_class=”no_stripe”][vc_single_image image=”2709″ img_size=”full”][vc_column_text]An administrator needs to enable the performance bar for app users. Do this from the application settings menu > app properties. You’ll find the checkbox in the performance options section. If the performance bar is already enabled but you don’t see it in your browser, go to your app’s home page and expand the More section at the top right. Under there, you should find a option to Show Quickbase Performance Bar.[/vc_column_text][vc_single_image image=”2712″ img_size=”full”][vc_single_image image=”2713″ img_size=”full”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”4. Use formula variables” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]You can use variables within formula fields to hold values you want to use in your formula. You define them using the var keyword and declaring the type of data the variable will hold, such as text, number, or bool (true or false). Variable declarations need to be terminated with a semicolon. You can refer to variables in other variables or in your formula by prefixing the variable name with a dollar sign. So, if you have a variable named quantity, you refer to it as $quantity.

Say you have a field that should show whether a person’s average heart rate was in the aerobic range during a workout. There are several steps needed to determine this. First, you need to calculate the person’s maximum heart rate, which is 220 minus the person’s age. Second, you need to know the minimum (60%) and maximum (85%) heart rate that is considered aerobic.

You could write this formula in a way to show others how clever you are:

If([Average Heart Rate]>=(.6*(220-[Athlete – Age])) and [Average Heart Rate]<=(.85*(220-[Athlete – Age])),true,false)

Or you could write it in a way that others will be able to understand and maintain:

// define the variables. This isn’t the formula yet.
var number maxHeartRate = 220 – [Athlete – Age];
var number minAerobic = .6 * $maxHeartRate;
var number maxAerobic = .85 * $maxHeartRate;

// Here is the formula that determines what the field will hold
If ( [Average Heart Rate] >= $minAerobic and [Average Heart Rate] <= $maxAerobic, true, false )

This is a much better approach than either creating other fields to hold the intermediate calculations or writing a complex formula with nested calculations that would be hard for others to understand and debug.

Learn more about formula variables in the article at Quickbase Help: http://help.quickbase.com/user-assistance/#formula_variables.html.[/vc_column_text][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”5. Add a section heading element to reset the width of fields” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]We’ve all cringed at forms with ridiculously and unnecessarily wide fields in them. In the example below, does “marital status” really need to stretch that wide?[/vc_column_text][vc_single_image image=”2718″ img_size=”full”][vc_column_text]On the other hand, maybe you like the way everything lines up in a perfect grid. Sometimes I do too.

In any event, when designing forms, you can reset the spacing and width of fields by adding a section heading element. In cases like this, we often turn off the form property “Show horizontal rules between sections.”[/vc_column_text][vc_single_image image=”2719″ img_size=”full”][vc_column_text]This is what it looks like after the extra section heading is added:[/vc_column_text][vc_single_image image=”2720″ img_size=”full”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”6. Type the letter “t“ in a date field to fill it with today’s date” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]Date fields slow down data entry. Even many touch typists feel clumsy and slow trying to type in dates from the keyboard, and switching to the mouse to use the date picker can be awkward. If the date you need to type happens to be today, a cool shortcut is just to type the letter t. Quickbase will fill in today’s date automatically for you.[/vc_column_text][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”7. Star your favorite reports” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]If you find yourself going to the same few reports over and over again, click the star icon at the top right to add them to your favorites. Then, they’ll just be a click away from your Favorites drop down at the top of the page.[/vc_column_text][vc_single_image image=”2723″ img_size=”full”][vc_single_image image=”2724″ img_size=”full”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”8. Save time and your memory with your list of recently visited records and reports” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]While we’re talking about the favorites menu, here’s a hidden gem: a continually updated list of the records and reports you’ve most recently looked at. This is great if a phone call interrupts what you’re working on and takes you to another record. Just click your Favorites dropdown and then expand the Recently visited in this app section to see the list, then click on any of them to jump right back to where you were before.[/vc_column_text][vc_single_image image=”2729″ img_size=”full”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”9. Include a “delete-after” date in the title of ad hoc reports” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]Quickbase apps can get cluttered with lots of reports that were made to be used one time. It makes maintenance easier if you add a delete-after date to the title so administrators will know a report can be removed safely. Date it at least a couple weeks into the future in case you have to come back to it in the next few days.[/vc_column_text][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”10. Delete records in bulk (carefully!)” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]There’s a faster way to delete records in bulk than grid edit. Create a new table report that filters records to show only the ones you want to delete. Then click More > Delete these Records and voila. Just make sure the report contains exactly, and only, the records you want to delete because this can’t be undone.[/vc_column_text][vc_single_image image=”2732″ img_size=”full”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”11. Jump back to the top of a long report with the little white arrow” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]You don’t have to scroll all the way back up to the top of a long report. You may not have noticed the little white arrow that appears in the top middle of your browser viewport when you scroll down a ways into a report. Just click it to jump right back to the top of the page.[/vc_column_text][vc_single_image image=”2734″ alignment=”center”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”12. Have fun when the Internet is down” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]Quickbase runs in the cloud, which meant that our team could work as normal from Greenville, South Carolina, even though we had evacuated from Hollywood, Florida ahead of Hurricane Irma in 2017. But that means when your Internet is down, your connection to Quickbase is down too. If you use Google Chrome (our preferred browser for Quickbase), you can play the dinosaur game while waiting for your router to reboot.

Press the space bar on your keyboard to start this little arcade game. Press space to jump over the cacti and other obstacles in the path of your T. Rex.[/vc_column_text][vc_single_image image=”2736″ img_size=”full” alignment=”center”][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column width=”2/3″][vc_custom_heading text=”What if I get stuck?” use_theme_fonts=”yes” el_class=”no_stripe”][vc_column_text]Quickbase is intended to be user-friendly, but it can still be frustrating at times. What should you do if you hit a roadblock with reports, formulas, relationships, or building an app? Quickbase Help is a well-organized compilation of frequently asked questions. The Quickbase Community forum is a good place to ask other users for help. But for more support, nothing beats having an expert on speed dial.

At Watkyn LLC, we specialize in supporting Quickbase users. We can get you set up, or solve any problems you might be having. For a free consultation, email us at hello@watkyn.com or call (954) 900-6690.

Our thanks to Ann Swelgin (#6) and Laura Thacker (#2, #7) for suggesting several of these helpful Quickbase tips![/vc_column_text][vc_empty_space][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row][vc_column][stm_post_about_author][stm_post_comments][vc_empty_space][/vc_column][/vc_row]

2 thoughts on “12 Quickbase Tips and Tricks”

  1. There are some great tips here! One thing I’d like to add is, not only do formula variables make formulas easier to read and maintain, but they often make formulas run faster as well.

    Let’s say you have some expression (like [Subtotal] + [Tax]), or even just a field reference (like [Subtotal]), that appears multiple times in your formula. If you replace those with a formula variable, the performance of the formula will be better. This is because formula variables cache field values, meaning that QB will need to query the value of your fields a smaller number of times to compute the formula’s value. This can be especially helpful if your tables have large numbers of records!

    Product Manager
    QuickBase, Inc.

  2. Great list! #4 is my favorite and the same concept applies to many coding languages.

    #12 has me looking forward to the next time the internet goes down 🙂


Leave a Comment

Call Now Button