# Search for RowId in googleSheets

**URL:** <https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121>\
**Category:** Questions about Thunkable X\
**Created:** [September 29, 2023, 1:17pm UTC](https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121 "2023-09-29T13:17:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeroen.mulder](https://avatars.discourse-cdn.com/v4/letter/j/977dab/32.png) [@jeroen.mulder](https://community.thunkable.com/u/jeroen.mulder)\
**Post date:** [September 29, 2023, 1:17pm UTC](https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121/1 "2023-09-29T13:17:48Z")

</div>

Hi I am trying to find the rowid of an item in a google sheet table but it does not work.  
I have this table on a sheet called CountryContacts  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/4/a47f549d21111b9703dea567a7ccea2632d80445.png)

I want to find the rowid of the countryname which I enter in a text input box  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/4/540a88f6c7f646a4bc21ea704519cc8f44e0ba97.png)

These are my block…

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/0/70f14b30c3e7d2e964fe4948f6e92bf14eda3211.png)  
It always returns 0 (so it cannot find the data)  
What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\
**Post date:** [September 29, 2023, 2:30pm UTC](https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121/2 "2023-09-29T14:30:46Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/d/5da2fe34b820164f11f15e42f65ef9eb177d1d2d.png)

Remove this list block.

---

<div class="post-metadata">

**Author:** ![jeroen.mulder](https://avatars.discourse-cdn.com/v4/letter/j/977dab/32.png) [@jeroen.mulder](https://community.thunkable.com/u/jeroen.mulder)\
**Post date:** [October 2, 2023, 7:10am UTC](https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121/3 "2023-10-02T07:10:32Z")

</div>

Thanks. That did the trick.

It is confusing because in doc it shows:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/4/64fc69db74be9264a3a60afedabd96ce9250482a.png)

I did not realise that  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/e/1e4ffecdd019fdc0e698a72424efcd158db0abcb.png)  
is an example list. So I removed all but one element.

But this all makes sense now. Maybe other beginners might find this answer helpful too.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 2, 2023, 2:23pm UTC](https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121/4 "2023-10-02T14:23:58Z")

</div>

I can be confusing but the difference is that “a” and “b” are not lists… they are text strings, whereas the “list of values” block is a list. Anything that is already a list does not need a [gear] list block in front of it.

A pretty much never use the [gear] list block except when initializing list variables.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [December 31, 2023, 2:24pm UTC](https://community.thunkable.com/t/search-for-rowid-in-googlesheets/2620121/5 "2023-12-31T14:24:34Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.