Authentication Form

[carterhobson]

Hello,

I am working on building an authentication form for my app. There will be two tables involved, one being the authentication table, and the other being the authentication keys table. The authentication keys table will have IDs in one column and a full name listed in the other column. The form will use Valid If expressions to verify the form by comparing the ID entered to an ID in the auth keys table, to grant access. I would also like to keep track of a full name in the authentication form possibly by ref or just to fill in the name, either way, I would like it to be automatic, so when you fill out your ID in the authentication form it will auto-fill your name or reference to your column in the auth keys form. Which expression would best fit for the auto-fill function?

Thanks for the Help!

[Marc_Dillon]

https://help.appsheet.com/en/articles/1090811-dereference-expressions

[carterhobson]

Looks like this would work if I was starting out with the REF and then gathering other details, however in my case I would like to match up other details to select the REF as described above.

[Marc_Dillon · Accepted solution]

Oh ok, you need LOOKUP() then.

https://help.appsheet.com/en/articles/2357309-lookup

[carterhobson]

Here is my goal, and what I have done so far;

I have a form with the field "Access ID"

I have a VALID IF constraint to ensure the "Access ID" Matches one of the values of the column "Access ID" in the "Users" Table.

I would now like the Ref field in the form to auto-populate with the User that has the "Access ID" Matching the "Access ID" just entered in the form. I have tried many expressions, however, they all make the field vanish. I would like it to show.

Thanks for the help!

Carter