Recommendations for adding / editing user interface table data when filtering

Question

Does anyone know. If there are any recommendations for editing / adding data in the user interface table when filtering its data?

Example 1:

Suppose we have a table with two options: add a new record and edit the selected one. In addition, the table has the ability to filter data by column A.

Now, if the table is filtered by filtering column A with a value of '1', and I want to add a new record with a value in column A that matches the filter's requirements, what should happen:

• The table should update and display the filtered records with the selected new record added.
• The table should have a reset filter and show all the records that have chosen a new one.
• The table should not do anything and display the filtered records as they were. The added record will be displayed when the filter is reset.

For me, intuitively the best solution is number 1. But then how to solve the problem in example number 2:

Example 2:

If the table is filtered by filtering column A with a value of "1" and I want to add a new record that has a value of 2 in column A, what should happen:

• The table should display the filtered records with the selected new record added, although it does not match the filter.
• The table should have a reset filter, and all records should be displayed with the new one selected.
• The table should not do anything and display the filtered records as is.

---

The same thing happens when we filter records, and in the selected record we want to change the value on which the filtering was performed. Should an edited record than disapear or filterre, reset?

Or maybe the best way to disable add / edit operations during filtering?

Answer 1

I do not know if there are any recommendations about this, but I also ran into a problem earlier. Two different solutions that I came up with:

• The edited / inserted record should not be filtered out until the next filter or reset filter is applied. The entry should also appear on a different (i.e., a darker background color or icon or tooltip) than others, implying that it has been edited and not filtered.

• The record should be left in focus after editing or pasting. Once it loses focus, the filter should be applied to it. The ideal solution is if the recording is filtered, it should not disappear immediately. For example, it can become invisible with animation.

Answer 2

I just checked google docs and libre docs, both of them just display the new entry regardless of the filter. You need to reapply the filter to hide them from the view (in both cases, column "A" is filtered by "value 1"):