Can I use this extension to get filterd range data from spreadsheet like a range of data in bw two dates?
for get filtered range data from spreadsheet you need to take lecture of spreadsheet query and try it with this extension query block
Catch the web got response content in a global variable and from this varibale ry to remove the index 1 using the block remove the item from the list (global list ) index (1) - this willl remove the header…
We developed new version are you join beta test program for this extension V2.
Only for 10 users. Telegram: Contact @Google_Sheet_Extension
Hello, I am making an APP and I need to take each data in the column, but when receive the results come the all date in the row that have the name of filter. How can I take each data the row?
based on your blocks, this block will return the last data
here use one loacal or global variable to print the index 2 items and then print the variable into the label
V2 work with Private Restricted Spreadsheets.
I get row data and need to split received data in many labels and I tried this block and not applied.
Thank you for your support
This post was flagged by the community and is temporarily hidden.
Can you explain it in English
Please provide documentation for GotSheet. For variables are returned, namely:
What is data type for each and what do these values represent?
Does ‘data’ contain everything in the sheet? And in what format? As a dictionary or what?
Also, an example code snippet on how to parse/use data would be much appreciated.
in Advance google Sheet Extension
Output Response Everything Explain in Details
total rows int
Read Full Article
Parse Data String by using these blocks
I used your blocks arrangement for getting data in Label component from google sheet (using your provided .aix for google sheets). I got full column data in single Label. I will feel more obliged and thankful, if you could tell me the way I can get the data of only one cell in one label, and with next button, second cell data in second label and so on. Not in a list, but navigating with Next Button. Thanks
get list item position by list index block