1 Step Login
This option will first check if a given data is there in the database or not , if the data is there then it will getsreturn the row no of a specific data. Below it's explained how you can do it too...
To make 1 step login you will need the Search in Sheet block
Understanding the working of this Block
This block is meant to check if some data (unique data) entered by the user is there in a specific column or not.
inColumn : Name of column where you want to search for data (text input)
query : Data you wish to search for (can be text as well as integer input)
fromColumn : Name of column whose data you wish to get in return (text input)
Right now, in this docs ill be checking if a specific email is there in the email column or not, if its there then I will get the password in return
So as per the sample sheet I have taken for this docs, the name of the column where email addresses are stored is “ Email Address “ column.
In fromColumn we will enter name of column where passwords are stored. In my case the name of column is “Password”
This is how your block should look.
So now we will proceed to the “ GotSeachResult ” block
The first thing we have to check is that whether the response code we have got from the server is 200 or not.
If its not 200 then that means that there was some error, you can notify the user about the error in that case by using a notifier or maybe a snackbar.
If the returned response code is 200 then we proceed
Now, let’s understand the process a bit, we can get 2 types of values now, either it will return the password associated with the given email or else it will return 0.
So now, we will check if the password we have got in return is the same as entered by the user or not
If the returned value is 0 then that means the text entered by the user in the textbox is not present in the database.
I have used a notifier to confirm that the login was successful, you can use any other component as well such as open another screen
This completes our process of making a 1 step login system with CloudsheetsClassic Extension
Documentation by Team Cloudsheets