Quickbase has a formula language that is optimized for the Quickbase platform. This formula language supports 196 functions across 15 categories (date, time, text, math, data aggregation, duration, etc.). Local and global variables are supported. Formulas can reference nearly any field or record in an app via lookups, summaries and formula queries. The Quickbase formula language is expressed in common language terms and should be familiar for those with experience in Excel. With business developers in mind, the functions are intuitively named, fields are referenced by user-defined labels, there is not strict data typing, expressions use common operators, and syntax is minimal.
The formula language supports search and auto-complete. A drop down list is provided in Formula Builder to find fields and functions in context. The field list filters automatically when users start typing. Function structures are filled when selected. The Formula Builder color codes key words, provides line numbers, maintains indenting and spacing for complex formulas, and checks syntax before saving formulas.