Report or Chart
Text
Button Bar
Search
Reports List
Web Page

There are no widgets on the page.

Drag one here from the widgets gallery.

 

 

Step up to the automatic formula machine

Put it to work for you by spinning a few dials (or dropdowns) and pulling a few levers (or checkbox fields), and out will pop a ready-made formula you can use in one of your applications.

 

The machine can generate formulas for conditional data, thumbnails, and for styling your text. Read more about each type of formula below and click a button to get started.

 

Have any questions or ideas on how to make this app better? Tell us about it in the communty.

Conditionals

Automatically calculate values based on conditions in your app. You could use this kind of formula to dynamically set a price or discount, assign a sales rep or territory, determine a due date, or set a project's status.

 

View examples

Display image thumbnails on reports and record pickers

Help your end users find what they're looking for more quickly by displaying thumbnails when viewing reports or picking parent records. This is great for tracking things like products, assets, job candidates, and managed properties.

 

View examples

Style text

Add some visual flair to your app by customizing the look of your text. You can change the color or size, underline or bold the text, or even change a field's background color.

 

View examples

Display progress visually

Focus your users on what matters most, by adding a colorized progress bar to track projects, programs, etc.

 

View examples

Read more about formulas
Using Formulas in Quickbase | Formula Functions Reference
Quickbase University courses

Gaining Efficiency through Formulas | Advanced Use of Formulas

Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table