How if i want call data from some sheet in 1 google spread sheet in a range...? That can be possible to make it in 1 url? Or have another way to do that?
The answer was provided in that topic:
You can go a step further if you only want a specific range, for example A2:B5, and add the range to the url as well:
https://docs.google.com/spreadsheets/d/1mpC--JsHI9sdo9RDbLUGwTT_eoaV0DlgQKFsV3NJKk/export?format=csv&gid=2131997720&range=A2:B5
if I have 2 sheets in 1 Google spreadsheet and need data in a certain range, do I have to use 2 urls for the 2 sheets or can I just create 1 url? Cz i want to show those data from 2 sheet and show them in 1 listview
Please stop private messaging!
Just reply to the forum
If you want to get two ranges from two sheets in your spreadsheet, then you will have to make two calls from the app, one for each range.
You could create a third sheet and copy both of the ranges there, then just make one call to get all the data, but your would need to sort it out once the data is back in the app.
sorry for doing it ... i just found out if it was a private message because i am new to this community. so the third sheet is the way ...
You are not restricted to one Web component.
Consider making a separate Web component for each different query type, so you can catch the results in separate Events.