Extension: Ready Made Formulas

Formula fields can calculate new data from the existing fields in your base. However, writing quality formulas can be tricky. Issue with spelling, punctuation, and syntax can prevent a formula from running. Checking for edge cases and error conditions can also require very complex formulas.

This extension includes over a dozen "ready-to-use" formulas for common tasks such as

  • formatting numbers and dates as text strings to include in reports
  • generating urls for prefilled forms and prefiltered shared views
  • extracting attachment filenames and urls
  • manipulating dates
  • consolidating data from multiple fields into JSON format

Simply choose your formula, pick your table and fields, and select your options. Then, copy and paste the formula into your formula field.

Getting the extension

This extension is available in the Airtable Marketplace.

Upgrading the extension

You can purchase a license for premium features in my Gumroad store.

Lookup Fields

Lookup fields are the most problematic fields to use in formulas. This is because lookup fields sometimes act like regular data fields (text strings, numbers, etc) and sometimes act like arrays (lists). Arrays require special handling different from regular data types.

If you want to use a lookup field in one of these formulas, first convert it to a rollup field.