Quickbase Discussions

 View Only

The Automatic Formula Machine

By Brian Cafferelli posted 05-07-2019 17:41


The Automatic Formula Machine

Whether you're new to app building or have been at it for a while, many people find it challenging to learn how to write formulas. Would it help if you didn't always have to hand-code your formulas? What if you could create an If formula using dropdowns, like you do when you filter reports? Help docs, Quickbase University, and this community site are all here to help but today I'd like to announce that we're taking it to the next level. Introducing...the automatic formula machine.

The automatic formula machine is a shared Quickbase application anyone can use to quickly generate certain kinds of formulas:

  • conditional formulas  to track prices, discounts, project status, etc
  • image thumbnail formulas to display on reports and dropdowns
  • text style formulas: to control the color, size, etc of a text field
  • progress bar formulas: to display a colorized progress bar for projects, programs, etc.

This is an evolution of the Styled Text Formula Builder that I posted to the Quickbase Exchange a few years back, and I hope this saves you time as you build out your apps!

Access The Automatic Formula Machine here.

I'd love to hear what you think of the app, so if you have any questions or ideas for improving it, you can post them here in this thread. I can make periodic updates to either serve the above types of formulas even better, or I could add more categories of formulas if there are others out there which you all build frequently.


06-02-2021 13:43

There are a couple of button builder apps in the exchange.  It would be a nice expansion of this app to include styling of buttons for formula rich text fields.

One example:


05-09-2019 05:23

Brian, this is really great. A one-stop solution for all type users. Thank you for providing your expertise to the community.


05-07-2019 18:04

This is great for all users, novices and experts alike!  Really useful tool.

05-07-2019 17:58

This is awesome. One stop solution is always helpful. Thank you for doing this.