# Filter View by current row in Detailed Display **URL:** \ **Category:** Ask the Community\ **Created:** [February 20, 2025, 5:53am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169 "2025-02-20T05:53:27Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Chris\_DeAngelis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/chris_deangelis/32/45722_2.png) [@Chris\_DeAngelis](https://connect.superhuman.com/u/Chris_DeAngelis)\ **Post date:** [February 20, 2025, 5:53am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/1 "2025-02-20T05:53:27Z")
I have embedded at table into a “detailed display” canvas. At the top of the detailed display their is a “project name”. I want the embedded table to automatically filter so the rows show on the ones with the matching project names above. Is this possible? ---
**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\ **Post date:** [February 20, 2025, 8:03am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/2 "2025-02-20T08:03:22Z")
Hi Chris, Yes, this is possible with sub-tables. But in order to achieve this **you need to leave behind the string matching paradigm from Excel** and embrace Coda’s relations, which are infinitely more powerful anyway. I’m assuming that the detailed display belongs to the table `Projects`, and that when you open the detailed view you want to show, for example, all the `Tasks` that have this project assigned. This would mean that there is a `Tasks` table with a relation column pointing at the `Projects` table. Then you just need to create a `Tasks` relation column in your `Projects` table and give it this formula: `Tasks.Filters(Projects.Contains(thisRow))` → Which means, check the `Tasks` table and return the tasks whose `Projects` column contain the row that I’m currently watching. If you already have the ` Projects` column in the ` Tasks` table, Coda will create this formula automatically if you create a ` Linked relation` pointing to the `Tasks table` ![image](https://global.discourse-cdn.com/coda1/original/3X/a/0/a0bcd87946c95e4ea19b58a3e75b3cfe3bb85f08.png) Just make sure when you are editing the layout of the detail view, that you are displaying it as a table ![image](https://global.discourse-cdn.com/coda1/original/3X/9/2/92a13ebea2aa5bb558375ae77efbb8bc343c6550.png) Hope this helps, Pablo ---
**Author:** ![Chris\_DeAngelis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/chris_deangelis/32/45722_2.png) [@Chris\_DeAngelis](https://connect.superhuman.com/u/Chris_DeAngelis)\ **Post date:** [February 22, 2025, 5:26am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/3 "2025-02-22T05:26:07Z")
This is driving me crazy. I set up the relation in the tasks and my project table also is linked and filters so I have a column that shows all of the related tasks for each project. But when I put the table i my detailed display it doesn’t do anything it shows all the tasks. I can’t figure out where I am supposed to add a filter and what I am setting it to equal with all the relation and linked tables. Said differently, the selected project in the view do I filter the original source Project or I filter the related field in the Tasks? Do I add the formula in general formulas or first go into filters and add it. It is just not working for me with the Display View. Argh. Thanks so much for your help so far. ---
**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\ **Post date:** [February 22, 2025, 1:01pm UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/4 "2025-02-22T13:01:25Z")
If you share a document in play/edit mode I will be happy to point out where the issue is ---
**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\ **Post date:** [February 23, 2025, 12:35pm UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/5 "2025-02-23T12:35:42Z")
So you have a `Task` subtable, within the `Submission` detail view, and you were trying to filter that subtable, with this formula ![image](https://global.discourse-cdn.com/coda1/original/3X/5/8/589b1d6e46b19b484ecdb72f3328449bde5b1d4f.png) The filter within a table should return True for a given row, if you want it to be visible, and currently it returns a number of items, which Coda interprets as true for all the rows, and therefore all are displayed. I’ve adjusted your formula, so that it kind of works. But as you can see in the warning, you are comparing a text vs a list of texts, which is not the same thing. You would need to look into that, because I would need to invest a lot of time understanding your doc. ![image](https://global.discourse-cdn.com/coda1/original/3X/c/e/ce61b7f7786bc6ad676dc7a845279db68e6ea35f.png) In general I applaude your valiant efforts, you’re building quite an ambitious document. But I’m afraid you are punching above your weight, you still have not mastered the Coda basics and are trying to build relatively complex workflows. This is very confusing for you, time consuming for people willing to help you trying to decipher what were you trying to achieve and also if you are planning to use something complex as this built with your current skill level in production with people other than yourself, this will be a nightmare for everyone involved. I know you have your goal in mind and just want to achieve, but as I told you in another message, there are no shortcuts, you have to grasp the basics not only of Coda`s quirks, but basic relational databases and how to structure your tables to achieve your business goals. If you are in a hurry to implement something like this in a robust way, you should hire someone proficient in Coda. There are many in this forum, me included, who would be able to help you. Hope this helps, Pablo ---
**Author:** ![Chris\_DeAngelis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/chris_deangelis/32/45722_2.png) [@Chris\_DeAngelis](https://connect.superhuman.com/u/Chris_DeAngelis)\ **Post date:** [February 24, 2025, 3:14am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/6 "2025-02-24T03:14:59Z")
I cleaned it up and found out why it was pulling weird answers and had mixed fields. It is finally working well! That tip on true/false helped a ton. I still cant figure out why some related fields pull data immediately after I create them and sometimes not. I think the ordering of which table you place you build the relation first still gets me but getting close to seeing the logic. And found the filter within the relation column today too which was a big help. ---
**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\ **Post date:** [February 24, 2025, 7:24am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/7 "2025-02-24T07:24:35Z")
Your document is quite big and messy, so I can’t answer all your doubts about it. But did my answer at least solve your original question? ---
**Author:** ![Chris\_DeAngelis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/chris_deangelis/32/45722_2.png) [@Chris\_DeAngelis](https://connect.superhuman.com/u/Chris_DeAngelis)\ **Post date:** [February 24, 2025, 9:59pm UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/8 "2025-02-24T21:59:17Z")
I am working in another document. My apologies for not being clear. I fixed it and it works great now. There isn’t any problems anymore with what I have so far. My comment was saying that I can’t figure out the best order when setting up relation tables (start at project then task or vice-versa) and why. But either way if it doesn’t do what I want, I switch it and then it works for what I need. ---
**Author:** ![Melanie\_Teh](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/melanie_teh/32/45501_2.png) [@Melanie\_Teh](https://connect.superhuman.com/u/Melanie_Teh)\ **Post date:** [February 25, 2025, 8:29am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/9 "2025-02-25T08:29:33Z")
@Chris_DeAngelis i think the issue youre describing can be shed with some light from the following > [@Please explain the "switched relation and linked relation" advanced option](https://connect.superhuman.com/t/please-explain-the-switched-relation-and-linked-relation-advanced-option/46901): > > I am referring to the advanced option for linked relation columns Can someone point me to documentation that explains this in detail, or explain it here. I just have not been very clear on what this means exactly. Is the only difference that a linked relation offer 2 way editing? its not clear to me when why there are 2 options for this because the functionality is so similar. what am i missing? Perhaps this is a legacy feature? relation columns came first so those are preserved like they alw… > **[Create two-way table connections with linked relations | Coda Help Center](https://help.coda.io/en/articles/5614216-create-two-way-table-connections-with-linked-relations)** > > Once you've added a relation column, use linked relations to create a two-way connection between tables > **[Connect tables with relation columns | Coda Help Center](https://help.coda.io/en/articles/1385997-connect-tables-with-relation-columns)** > > Learn how to use relation columns (formerly Lookups) to connect tables in Coda. Easily reference another table directly from within a row. Cheers! Mel ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [February 28, 2025, 8:30am UTC](https://connect.superhuman.com/t/filter-view-by-current-row-in-detailed-display/54169/10 "2025-02-28T08:30:28Z")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.