Search for RowId in googleSheets

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

I want to find the rowid of the countryname which I enter in a text input box
image

These are my block…


It always returns 0 (so it cannot find the data)
What am I doing wrong?

Remove this list block.

1 Like

Thanks. That did the trick.

It is confusing because in doc it shows:

I did not realise that
image
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.

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.

1 Like

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