Hi,
I have created a shp list having : username, password and name. Based on this list the users are log in into the app. What I want is after the user enter his credentials, at the welcome screen, to appear into a label the name of the user who logs in based on the shp list.
For ex : username : John, password : randompass; name : John Johny. The text atribute of the label would be : "hello, " & name of the user who logs in, meaning hello John Johny.
What formula to use ? I don't want to use the function user();
Thank you, your help is appreciated !
Solved! Go to Solution.
What is in your list if you do not want to reference User()? If it references the user with another field as well, you just need a lookup. For instance if you had the email address and name and the user entered their email address, the label would be something like
"Welcome " &
Lookup(
YourReferenceList,
YourEmailField=YourUserEnteredField.Text
).YourNameField
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
User | Count |
---|---|
254 | |
250 | |
82 | |
44 | |
27 |
User | Count |
---|---|
343 | |
266 | |
126 | |
61 | |
58 |