Google sheets data return

[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

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

Sorry i dont know any language except English and tamil

[michel]

sorry, I said I don’t understand this part of the variable, and index, can you build a block for me to understand?

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

show screenshot of your gsheet table only, i will give the working blocks

[michel]

[michel]

I’m using F4: H4

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

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

I have used the same url mentioned in my earlier post and download values from A1:D1 but showed A1,B1&C1 values only into each text box

[michel]

Thank you master, I will test and tomorrow I return, here this afternoon, for now thank you

[michel]

Goodnight
I tested it and it’s perfect, last doubt, I called web1 in the save block to update the textbox as soon as I click the button, but to update it is necessary 2 click, you know why?

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

Do not use same web component for read & add. If you want use it with different buttons.

[michel]

Got it, Thanks Still-learning
Gowri SankaR, and everyone who helped me, I am closing this topic, it has been successfully resolved.

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

If you mark solution, it will be easy for others while searching for their queries.

Update: Please mark the post as solution which actually clears your doubt based on your topic?