Matrix extension

The matrix extension lets you plot your records as cards on a rectangular grid. Pick one field for the rows of the matrix and another field for the columns of the matrix, and you'll have a tool that you can use to plan and prioritize tasks, objectives, and initiatives in two dimensions. You can also drag and drop records to move them around the matrix and reassign values.

Adding a matrix extension

1. Open your Airtable home screen.

2. Create or open the base where you want to install the matrix extension.

3. Click Tools in the upper-right corner.

4. Click the Extensions option.

5. Click Add an extension.

6. Search for and locate the matrix extension.

7. Click Add, then Add extension.

Setting up and customizing a matrix extension

1. When you first install a matrix extension, it'll automatically open to the new extension's settings. From the settings, you will need to pick the table and view containing the records (rows) that you want to visualize.

2. Next, you'll need to pick a field to define the rows of the matrix and a field to define the columns of the matrix. Matrix extension currently supports the following field types for rows/columns: single and multiple select fields, single and multiple collaborator fields, rating fields, and checkbox fields.

3. Once you've selected the fields for the rows and columns, the matrix extension will plot your records in the cells according to the values in their row and column fields.

4. By default, your matrix will include a row and a column for records with empty values in the associated fields. This is useful for moving cards around if you haven't quite decided how you want certain values to be assigned, or if you want to move records around to clear their values.

   1. If you do want to hide the row and/or column for empty values, click the toggles that say "Only show rows with records" or "Only show columns with records" as desired.

   2. Note that the information above does not apply to rows or columns defined by a checkbox field, since the only possible values for a checkbox field are checked and unchecked.

Additional matrix extension configurations

• Reordering rows/columns with the field customization menu - If one of the fields defining the rows or columns for your matrix extension is a single select field, you can rearrange the order in which the select options appear by adjusting the order in the field customization menu.

• Use a conditional emoji in the primary field to color-code records - You can make your primary field a formula and incorporate emoji into that conditional formula to make the cards on your matrix more visually distinct.