I am trying to create a query that will only grab several columns (specified by me) and only limited data points, like, for example, last 10 or 20 entries, last 30 days entries or all entries from the current month.
I created a query that grabs the entire table from Google Sheets, and it is called query_1.
Below is my new query but it does not work. I need 2 versions: the front end users can select data range and the hidden data range that simply shows them data for the last 30 days.
Also, the query should update automatically (it is linked to Google Sheets).
What am I doing wrong?