The Automatic Formula Machine

  • 2
  • 3
  • Article
  • Updated 2 months ago
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, Quick Base 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 Quick Base 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



This is an evolution of the Styled Text Formula Builder that I posted to the Quick Base 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.
Photo of Brian Cafferelli

Brian Cafferelli, Quick Base Technical Marketing Manager

  • 1,608 Points 1k badge 2x thumb

Posted 2 months ago

  • 2
  • 3
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 938 Points 500 badge 2x thumb
This is awesome. One stop solution is always helpful. Thank you for doing this.
(Edited)
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,516 Points 4k badge 2x thumb
This is great for all users, novices and experts alike!  Really useful tool.
Brian, this is really great. A one-stop solution for all type users. Thank you for providing your expertise to the community.

Thanks,
Gaurav