# Pull existing row into filtered view

**URL:** <https://connect.superhuman.com/t/pull-existing-row-into-filtered-view/21124>\
**Category:** Ask the Community\
**Created:** [February 2, 2021, 9:19am UTC](https://connect.superhuman.com/t/pull-existing-row-into-filtered-view/21124 "2021-02-02T09:19:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cornelia\_Gamst](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/cornelia_gamst/32/19173_2.png) [@Cornelia\_Gamst](https://connect.superhuman.com/u/Cornelia_Gamst)\
**Post date:** [February 2, 2021, 9:19am UTC](https://connect.superhuman.com/t/pull-existing-row-into-filtered-view/21124/1 "2021-02-02T09:19:42Z")

</div>

Hi everyone,

So, I have a (very large) master table of something, say items in my household, and then I have different views of that table, say for each room a list of the items in that room (in this example I would have a column “room” and the view would use a filter on this).

Now, I might need to manually add (i.e. type) a new item directly in one room. Say “blue vase” in “living room”. If I start typing “blu…” I get suggestions, and one is the “blue vase”. (Oh, right! I added that before!) But since it is not yet in the “living room” view, apparently I forgot to tag it as “living room” in the “room” column. If I select the suggested “blue vase” from the auto complete, however, it will not pull the existing “blue vase” entry into the new view, but rather create a new entry “blue vase” with the “living room” label, which is obviously not what I want.

How can I pull the already existing entry into the current view of the table (i.e. only add the filter criteria and not create a new row)?

I can, of course, go to the master table, look for the entry and add the filter criteria there, but that’s not what I want. I want to do it directly in the view while I am typing it. Is that possible?

I wasn’t able to find a solution to my question, because I’m not really sure how to effectively search for it. (As you see my explanation became rather long…) So, I apologize for asking this again, if it was answered before. 🙈

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [February 2, 2021, 11:38am UTC](https://connect.superhuman.com/t/pull-existing-row-into-filtered-view/21124/2 "2021-02-02T11:38:56Z")

</div>

Hi @Cornelia_Gamst ,

I don’t know if I really got your point. I have created a simplified example along with its solution:

https://coda.io/embed/Fm9fAeALJp/_suHli?viewMode=embedplay

Let me know if this is going to the right direction.

**Please note**  
The `[beta]` implementation relies on the [beta text control](https://connect.superhuman.com/t/text-control-beta/20983). In case you are not subscribed, I provided a safe (yet a bit more cumbersome) implementation in `[safe]`

---

<div class="post-metadata">

**Author:** ![Cornelia\_Gamst](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/cornelia_gamst/32/19173_2.png) [@Cornelia\_Gamst](https://connect.superhuman.com/u/Cornelia_Gamst)\
**Post date:** [February 2, 2021, 11:44am UTC](https://connect.superhuman.com/t/pull-existing-row-into-filtered-view/21124/3 "2021-02-02T11:44:34Z")

</div>

Wow! @Federico_Stefanato this is great!

It’s not really what I had in mind. I was thinking of directly typing in the “Items per Room” View, but this is a very elegant circumvention of the problem!

I’m not sure I got your point about the beta text control, though. Will take a look into it. [Edit: Found out about it and will try to sign up, as it is indeed way more elegant in this scenario 😁]