How to get a value from google sheets?

Questions about Thunkable
1

Hi, How can I get all the values form google sheets? Like if the text = any username which is in the google sheet plz Tell me I need this so badly

2

Go to data sources.
And Use a get list of values block.
And check if the list contains the text.

1 Like
3

It’s not working Did you meant like this?

t
t1071×92 11.3 KB

:thinking:

4

No i mean check if the lists contains the text item.
You can find that block in the list drawer.

1 Like
5

What is list drawer?

6

How can I find it?

7

I am not on the new mod.

8

Its thiss one:
Screenshot_20210604-083330_Chrome

1 Like
9

oh thanks but which block?

1 Like
10

@thunkabot display help

12

Use the does list contain block

1 Like
13

like this?

r
r1000×77 9.75 KB

loop
5820
58201313×52 9.81 KB

14

Like this:
Screenshot_20210604-100652_Chrome
Replace the navigate to screen blocks with custom blocks.

1 Like
15

ok but now I want if the text is not = table plz help

16

Add a else to the if statement.
And put your code there.

1 Like
17

hope this one works. thanks for your time

1 Like
18

Edit each of your posts instead of posting several questions in a row. This is supposed to be a formal (for the most part) discussion.

Discourse lets you make a maximum of 3 posts in a row, so that tells you it is not a fan of continuous spamming either.

As codeswept told you in another topic of yours, this is a forum, not a chat room.

4 Likes