Inside this article
- 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
- 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.
Example 1 - Recipes and ingredients
We have two tables
- My Recipe Items
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:
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:
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.