App that has credentials stored in a database and only those credentials can be used to login

MIT App Inventor Help
1

Hello! As the title states, I'm trying to make an app that has only a login screen with pre-stored credentials that can be used to login. The problem is, I don't know how to store data in database without using, for example, a sign-up screen. Any help is appreciated.

2

Where are/will the login credentials stored ?

How will you know which credentials to use ?

3

I'm thinking the credentials should be stored in a google sheet.
As for the credentials, I have three pairs of usernames and passwords and they all can be used.

4

How will you know which credentials to use for a user's app ?

5

Ideally, the credentials only stored in the spreadsheet for example, if any credentials outside of the ones inside the spreadsheet is used, the login screen will return an error. Sorry for the lack of consciousness, it's like 3 in the morning here

6

Actually, on re-reading, when the user enters their username and password, you send these for checking against the values in your google sheet, if you get a match, then they are signed in.

7

Will the spreadsheet be 'restricted' or 'anyone with the link' ?

If there are only three sets of credentials, you should be able to pull them all down to the app and check them locally.

8

The spreadsheet will be restricted

9

You would need to either:

Set up your spreadsheet to be accessed by the AppInventor spreadsheet component

or

Create a simple apps script web app that will allow you to download the sign in data

10

Thank you! By any chance is there a tutorial on your website about the simple apps script web app?

11

(nothing is "simple" :wink: )

12

Thank you!

13

Follow up question: How do you incorporate the spreadsheet component in a login screen? Sorry, very new to mit app inventor 2

14

Here is a guide:

1 Like
15

Do I need to pay for the account? Or is there a free one?

16

You can get a Google developer Account for free. I can't remember (it has been a while) whether you need to provide billing/payment details.

17

Can you teach me? Sorry for asking for too much

18

I tried creating one, but I needed to pay upfront, and I don't have a credit/debit yet

19

You do not want a developer account to setup apps on the PlayStore, you want a Google Cloud Platform Account.

Did you follow the instructions here:

https://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html#1-create-a-google-developer-account

1 Like