What are subtables?
How to create subtables

When to use subtables

FAQs

Related Articles

What are subtables?

Subtables are tables that you can embed into expanded row layouts and detail table views. If one of your columns is looking up information from another table and outputs row references, you can toggle on the row details from that table form using the Display this column as a table option while in the editing view for the row layout:

Screen Shot 2021-08-09 at 4.37.21 PM.png

Subtables help you see more details about it by converting that row reference bubble into a view of the table, letting you see more details than just the name or display column. They serve as helper views that allow you to view and edit another table's rows without having to leave the current table to do it.

How to create subtables

To create a subtable, you must locate a column that outputs row references and toggle on the table option under the row layout editor. These row references can be from the same table or another table within the doc. You can create a subtable using a lookup column or a column set by a formula:

Column Formulas

You can set up a subtable to edit a column set with a filter formula. The formula should match this format so that the output is in the format of a table row reference: [Table].Filter(Argument).

Remember that the output of your formula must be a row or list of rows in order for this to work, so you'll want to avoid specifying a column in your filter formula unless that column contains row references.

If you also want the conditional formatting to show up, you can convert the column format into a lookup and set that with a formula as well.

Lookup columns

Lookup columns must have the multi-select option turned on and at least 1-row reference manually selected to convert the row layout into a subtable.

After you've set up your table column and there are visible table row references in place, expand the row or convert your table to detail view. Then click on the three dots in the top-right corner and select Edit Layout. If you're converting a lookup column, you may notice it automatically gets converted into a subtable upon entering the edit row layout menu.

If you're converting a Text column into a table, you'll need to manually toggle the option to "on" for it to work.

Screen Capture on 2022-07-14 at 19-00-03.gif

When to use subtables

Use subtables when you want to track subtasks of projects or to track inventory. It allows you to embed lists into table rows that you can then reference or action (e.g. with automations or filters) and add additional details.

FAQs

Why am I not seeing something I added in a subtable in my parent table?

If you run into this issue, this may be because you have a filter on your parent table. Also note that if you set up your subtable with a filter formula, we automatically update new rows to match that filter requirement so it is not immediately filtered out of the subtable.

For example, if your filter argument looks like this [Table].Filter([Name] = "Renita"), all rows added to that subtable should automatically have the string "Renita" populated under the Name column so that the row shows up in your subtable.

Related Articles

Using layouts

Using Lookups

Overview of Tables

Using the Filter formula

Did this answer your question?