I am looking to create a login an password screen using supplied credentials in an APP LOCAL DATA table. I have found a couple of previous post but the links to examples are expired or deleted. I didn’t think it would be hard but I just cant get it to work. As you can see from my screen shots simple is better. I had to stop working on this app and have forgotten how to do some things but trying to get back up to speed again. Thanks in advance.
Still trying different things to get it to work like I want. Screenshots below are my latest attempt. I’m not sure why its not looking to the APP LOCAL DATA spreadsheet for the username and password.
Hi, there are some things you can do to figure out:
First of all i think, but i’m not sure, you are using this block in a different way then it’s supposed to:
The “numbers of rows”, will give you the total amount of rows in the table.
What i suggest you to do is to go step by step and create a debug label to actually check that you are retrieving the values you want.
-
Create a label and plug the “numbers of rows” block to its text and see if it’s effectively the value you want
-
Use the same label and see if you are actually getting the value you want from here:
I’d say start from here, and make sure you do a debug lable everytime you are facing an issue, at least you can go step by step and see where the issue actually is (if it’s the password, the login, the “numbers of row”, ecc…"
Let us know how it goes
I think I understand what you are recommending. I replaced the block you had questioned if it was used correctly. I replaced it with a label for row 1 and it works. How do I get it to look at all rows say 1 to 20? Thanks for your help and Happy Thanksgiving too.
I did something quite similar for an app for a client, have a look here i’m sure it can help:
I usually use the skyblue block “In List find first occurence of item”
What it does it give you back the number of the item in the list, when a certain word or phrase is found, for example in the list:
apple
banana
pear
If you look for the item “apple”, it will give you as value the number 1, as it’s the 1st of the list, banana will give you 2, and so on…
I am sure there are many ways to do it, but this one always worked for me.
What you need to do then is replace the label “1” in your blocks, with:
“In list - list of value created local db, Table 4, Password - find the first occurence of item - Password Text”
Or at least play around with it and see what works for you the most
make sure you use the purple block “trim both spaces” as it’s case sensitive and an user may add a space while writing
Hope it’s clear enough and it helps
Thank you very much. It worked like a charm I didn’t know I needed. Happy Thanksgiving.
1 Like