Is it possible to limit the number of boxes in a list view?

[david_dominguez]

good morning
I import a googlesheets file that has many rows, is it possible to show me only the last 10 rows in a list view?

thanks in advance

[ABG]

Search this board for Go Scroll Yourself for an example.

[david_dominguez]

Forgive my inexperience, but I didn't see in the Go Scroll Yourself what I need to do.....

I put the block for you to see it, in the list view I see all the rows of the google sheets and I only want to see the last 10.

thanks for your help

[Taifun]

@david_dominguez

to show me only the last 10 rows

You probably could use gviz together with the limit clause, see

Use gviz to get and query google sheet data

[gvizscreen1] Guide on how to use the google visualization API to get and query "public" google sheet data Use gviz to get and query google sheet data Note: this approach has been knocking around for years, e.g. https://puravidaapps.com/spreadsheet.php, but I have never seen it "properly" explained like this...

and Query Language Reference (Version 0.7)  |  Charts  |  Google for Developers

Taifun

[TIMAI2]

Or if you want to call back all the data for other purposes, something like this:

[david_dominguez]

Thank you very much, it was difficult for me but I finally achieved the goal, I was also able to filter by word, great

[Taifun]

@david_dominguez

it was difficult for me but I finally achieved the goal, I was also able to filter by word, great

great!
what about providing a screenshot of your solution to help others with similar problems in the future?
Taifun

[david_dominguez]

This filters by the page, by row A and also by the phrase (interv: BARC)

/gviz/tq?tqx=out:csv&sheet=ORIGEN&tq=SELECT+A+where+A+contains+%27(Interv:%20BARC)%27

limit 100 limits to 100 the number of matches that will be displayed in the list view

[TIMAI2]

You should UriEncode the entire query

e.g. SELECT ... limit 100