Contents x
Common Solutions: Advanced
5 Articles  in this category
  • Print
  • Dark
    Light
Contents

Common Solutions: Advanced

5 Articles in this category
  • Dark
    Light

Displaying quarters in a fiscal year

You can use a formula to display the quarter of a fiscal year based on the date in another field, even if your fiscal year is different from the calendar year. As an example, let's say your fiscal year runs from June through May; that means your f...
Updated on : 06 Jul 2022

Build a custom form URL filler using ENCODE_URL_COMPONENT

The ENCODE_URL_COMPONENT formula function translates strings of text and characters into language that can be read in your browser's address field. Because URLs can only read special characters (e.g. %20 instead of a space), you have to encode any...
Updated on : 13 Jul 2022

Add a line break using \n

When working with formulas, especially when combining several fields of information, it is often helpful to program in line breaks and other formatting features to better display the result of a formula. By using "\n" in a formula, you can program i...
Updated on : 15 Sep 2022

How to conditionally display missing field values

This article will cover how to check for values across different fields, and display an automatically updated list of any missing/remaining values. We'll use a combination of an IF statement, as well as the AND and FIND functions, as well as an alte...
Updated on : 06 Jul 2022

Can I create a SQL query in Airtable?

You cannot directly query an Airtable table, but you can use a view to accomplish the same goal. The best way to think about translating queries to Airtable is that each view contains (roughly) the output of a query on a single table. A SQL query...
Updated on : 25 Aug 2022