Match text in google sheet

MIT App Inventor Help
1

Good day,

I need to find data in a google sheet. (I am using the mit build-in blocks)

I have a textbox where user will type in a password, Then the app should read the google sheet to see if the password is on the sheet already.

please advise what is best blocks to use

Thanks in advance

2

This

image

Will return the row number (as a list) and then the data in the row (as a list) if the password is found.

If password is not present it will return an empty list

3

Thanks for advise.
But this seems not to be working.

I copied your blocks.

4

Show all your relevant blocks

Show example of your google sheet data

Do other blocks work using the Spreadsheet component / is your service account setup and you have a working credentials.json in place ?

5

20230428_002103
20230428_0021033000×4000 1.04 MB

20230428_001928
20230428_0019284000×3000 262 KB

I use your easy post script to add to my google sheet.

6

You didn't answer this ^^^^

7

Service account is not setup as I don't need a service account if I am only going to read from google sheet.

credentials.json not setup either.

8

Is Google Sheet set to Anyone with the link?

9

Just tested without credentials. You are right, for me it slowly crashes the companion app, no response and no error. ( I have reported this up the line)

A workaround would be to use a gviz query:

image
image909×367 41.6 KB

or extend your google apps script to handle the search/match and response

Also

You should not really store passwords in plain text.

10

Hi,

Thank you for getting back to me.
The blocks you advised, not working either.

Can you please advise how to add to the script, meaning what to put in and where.

regarding the password, just in plain text temporally. Planning to change the password.

11

See HERE for a fuller explanation of using gviz

You may also find this of use: