I have a filter view in Google Sheets that does not refresh when new data comes in via Google Forms.
To refresh the filter view, I can remove the filter and apply it again, or even just click "OK" in the filter menu without chaning anything. F5 and closing/reopening the page does not work, though.
I need a way to automatically refresh the filter view when new data comes in. Or at least to get the refreshed filter view when I close and reopen the website witout having to manually fiddle with the filter settings.
Any ideas how I could do this? Maybe with a Script that fires onFormSubmit?