When adding an item to a filtered few, prefill to match filter


#1

I have a table with “projects” which are linked into a second table with todos, when filtered, and I add a new item, the linked column value would be the value that matches what would allow the new row to be seen in the filtered view.


#2

This already happens in a grouped view.


#3

I think it makes sense


#4

Would love for this to happen. My whole team constantly creates double records due to this issue. It is so nice when we are able to use a grouped view solely instead of a filter so that records don’t disappear constantly, but this isn’t always feasible.


#5

I also create a lot of duplicates to create a record, and then edit it :sweat_smile:


#6

So, it looks like the reason this happens is because, instead of acting as a single select list, linking to a record from another table is simply matching the string, and filtering it acts as a string, instead of filtering to a single value.

When I filter on a single select that is not defined in another table, this behaves as expected.