Log in to the application

Discussion
,
1

Respected members, please help. I made an application for employees so that they could know their salaries through the MasterCard numbers of each employee. I succeeded in this by designing a project on Google Script and adding the link inside the application through the web viewer, and the application is working now. Now I have stored the employees’ MasterCard numbers on a Google Sheet file, and now I want only the people whose numbers are in the Google Sheet file to be able to open the application and log in to the application. And not just anyone

2

You can use spreadsheet component.
You can watch this video

3

You can create the login system easily. Just use the stored mastercard number to the user current entered number. Match the stored number with entered number, if the number was matched then open main screen, else show notification Account doesn’t exist.

Ex:- :if entered number = stored number
:then open main screen
:else show notification account doesn’t exist

Note: Data easily accessible by anyone if they entered right number.

4

Thank you all . The first question is: Is it possible to add new MasterCard numbers for new employees to allow them to access the application and log in without the need to update the application? For example, store MasterCard numbers in a database connected to the Internet, through which new MasterCard numbers can be added for new employees to allow them to open the application without the need for a new update to the application. Secondly, I am still a beginner. Can you make a video or pictures with the blocks to explain how this can be done?

5

Hi! @deyala33 Yes, you can do this easily. But I will suggest you to use baserow/airtable as database, by using these database you can (employees) can easily update information or create account. Already registered users can login easily or new user able to create account without any updates, just they need to enter mastercard number and then new account is created.

Suggestion: Please do not use sensitive information such as; debit/credit/any other card number as user identity, this may lead to financial loss