Pull existing row into filtered view

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. :see_no_evil:

Hi @Cornelia_Gamst ,

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

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

Please note
The [beta] implementation relies on the beta text control. In case you are not subscribed, I provided a safe (yet a bit more cumbersome) implementation in [safe]

1 Like

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 :grin: ]

1 Like