How to modify the FILTER function in Google Spreadsheets so that you can add values?

Question

Google Apps Script

Hello guys, please tell me if it is possible to do something with the FILTER function so that I would be able to change, for example, the values ​​of the "employment" column without going to the database. If this is done now, the filter will break because "The array is not allocated and this would lead to data being overwritten"

Answer 1

In this form, no way.
You can make the data insertion by a script - you pressed the button (either by a timer or by a trigger) - the data flowed from the "base" into the sheet. And add to the script sending data from the sheet to the "base". All this is solvable, but that's still a trolleybus.