Google sheets data return

[michel]

how to return the value of a cell from google sheets to a text box in the kodular app?

[Still-learning (1-2-3-4...)]

better search in forum… There are plenty of solutions and suggestions are available

[Still-learning (1-2-3-4...)]

try this

How to get the requested/duplicate entries from the googlesheet?

@Taifun , Suppose if i adjust the query to search the name matching with date , then results turned empty. I dont know why. I used the same blocks but instead of namelabel.text i used datelabel.text field. Is it not possible to search the field based on date? And i display the date in the label by using web component web site address : http://worldtimeapi.org/api/ip and the blocks are , [Screenshot_2] Query link look like this, https://docs.google.com/spreadsheets/u/1/d/10ZXG9P0s4mYQhJn…

also

https://community.kodular.io/t/google-spreadsheet/108395/28

[aditya_chaturvedi (XyberNeo AKA Aditya)]

Hi,

You can try cloudsheets classic/pro for it. We have a dedicated block for this purpose.

If you have any issues using it or you need any assistance, do not hesitate to send me a pm

Regards

[TimAi2 (metricrat)]

Get a Single Cell from a Google Sheet

[michel]

what extent are these blocks?

[TimAi2 (metricrat)]

@michel

what extent are these blocks

Explain/enquire further…

[michel]

@michel

what extent are these blocks?

which blocks belongs to which extension?

[TimAi2 (metricrat)]

@michel

which blocks belongs to which extension ?

There are no extensions…

[michel]

I don’t understand, I don’t find these blocks in my project.

[michel]

I found. sorry for my innocence

[michel]

Could you teach me how to do it when screen 1 starts text box 1 starts with cell A1?
I can’t seem to unfold it.

[Still-learning (1-2-3-4...)]

@michel ,

My actual google sheet url is
https://docs.google.com/spreadsheets/d/1bxS6hZwhqaVY0R89ah3gMoxTk8xlPcf2s4AvBb6aZxY/edit#gid=0

But i made changes in the above URL to get A1 value only as below,

https://docs.google.com/spreadsheets/u/1/d/1bxS6hZwhqaVY0R89ah3gMoxTk8xlPcf2s4AvBb6aZxY/gviz/tq?tqx=out:csv&sheet=Sheet1&tq=&range=A1

Whenever screen initialize the block will give only A1 value.

Try this, if it not works, comment again…

Update:
Before you share url in the block you need to give minimum permission to others to view atleast the googlesheet

[michel]

Good afternoon, it worked perfectly, very grateful for the help,
just one more doubt, I registered 11 data, if I clean the spreadsheet and re-register it, register on line 12 and not on line 1, why?

[Still-learning (1-2-3-4...)]

Instead of cleaning try to delete the cell values and try. if your got answers pls hit solution, it will be helpful for others…

[michel]

Goodnight friend,
to return the value of a cell your help was spectacular, now and if I need to return 3 cells to 3 textbox it would look like this with 3 WEB or to simplify, it seems that with 3 web it was a little slow.

[Still-learning (1-2-3-4...)]

No need to use three web

Tell me Is all the value present in the same sheets?

i.e in A1, B1, and C1

[michel]

yes, they are on the same sheet,

[Still-learning (1-2-3-4...)]

then in the range you use A1:C1
instead of getting response content in text box use any variable.

then use in text box .text1>select list item(get global variable) index(1)
text box .text2>select list item(get global variable) index(2)
text box .text3>select list item(get global variable) index(3)

[michel]

I did not understand this part