Account System with Spreadsheets

MIT App Inventor Help
1

im making an account system but i ran into a problem.

i want app inventor to search for a certain username in the usernames column in a google spreadsheet (im using the spreadsheet component) and then i want to compare the text from the password box to the password in the passwords' column at the same level as the username. let me make it simple:

i want to get the username's location on the spreadsheet and shift some columns until i hit the passwords one and compare the password to the password box's text

image
image941×347 24.3 KB

2

deleted

4

Is your google sheet restricted access (e.g. you are using a service account) or open to "anyone with the link" ?

5

restricted access

6

Have you considered using the "QUERY" block which could handle both issues at once ?

7

i didn't but how do i use it?

8

Sorry, just looked, they appear to have removed it for the delivered version....

9

how do i solve my issue then?

10

It may be that you can use the ReadWithFilter / ReadWithPartialFilter blocks, they appear to do a similar thing.

Why ReadWithQuery was removed I do not know, it was the most powerful method in the entire component!

1 Like
11

Oh, thanks! I'll go read and try to understand it on the documentation.

12

HEY WAIT A MINUTE

i cant understand it!! how does it work?? how do i implement it in my code??

13

Something like this (where textbox is your login username)

image

See what comes back and work with that data ?

14

so it returns all the data from the row that the username is on?

15

I do not know, does it ?

If it does, then all you should need to do is check the password list item ?

16

so when it returns the value, i split the password from the data and compare it?

17

image
image742×463 24.7 KB

is this good code?

19

What you get is a Label with return_data?

erererer
erererer713×332 52.7 KB

20

please just tell me how do i find the password in return_data

21

What you get is a Label with return_data?

22

connect the app with companion, in mouse click right side, then preoceed with Do it and share us your result

image