Inside this article

What are subtables?
How to use subtables
Subtable examples
FAQs

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

What are subtables

Sometimes the rows of our tables need to be very detailed. We might want to see all of the contacts we have for a company in our Active Clients table. While a list can be a great start, it's not the most efficient way to work with your information. Whenever one of your columns is looking up information from another table, subtables help you see more details about it by converting that column cell into table - letting you see more details about the record rather than just display name.

How to use subtables

  1. Create a table

2. Create another table with a lookup column to the first table

3. Connect your table information using a formula with thisRow

  • [Table you want to pull from].Filter([Column you want to pull that matches the item in this row]=thisRow)
  • Just make sure you have multiple records in the table you're pulling from
  • In the example below, we want to look at the My Recipe Items table, look only at the ingredients in My Recipes that match this Row (e.g. only show me ingredients for Recipe A)

4. Expand the row and click the pencil icon and toggle Display as table on. 

Note: if your column is hidden, make sure to drag and drop it out of the hidden column section.

Subtable examples

Example 1 - Recipes and ingredients

We have two tables

  • Recipes
  • Ingredients

Our ingredient table has a lookup column that pulls recipe names:

In our main recipe table, we show the ingredients in a column using this formula:

Once we open the row, we can see the ingredients in a table and make additions:

Example 2 - Clients and interactions

We have two tables:

  • Clients
  • Interactions

Our interactions table has a lookup column to the clients table:

In our main client table, we pull all of the relevant interactions in with a formula:

Once we open the row, we can see each interaction and make additions:

FAQs

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

If you run into this issue, you'll want to check what filters you have on your subtable. If your subtable has multiple filters to compare to (e.g. thisRow and <100, you won't see the full record back into the parent table.  

Did this answer your question?