Common Solutions: Advanced

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 fi...

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...

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...

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...

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...