# Company Directory + App Users **URL:** \ **Category:** Ask for Help\ **Created:** [January 11, 2024, 1:26am UTC](https://community.glideapps.com/t/company-directory-app-users/69459 "2024-01-11T01:26:15Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Brenten\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brenten_taylor/32/68533_2.png) [@Brenten\_Taylor](https://community.glideapps.com/u/Brenten_Taylor)\ **Post date:** [January 11, 2024, 1:26am UTC](https://community.glideapps.com/t/company-directory-app-users/69459/1 "2024-01-11T01:26:16Z")
The User database in my app has a Relational column that relates to people in our company directory by name. It then has a column that is a Lookup to find the email address through the company directory relation. ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55cf8545ea6d56689ce618bdfa9ebcec02531230.png) When I set the User table as the source for “Users & Authentication” in settings, I get this error trying to login: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d33622591845561daec7c5fbe72d2a1becb3a41e.png) Is there a problem with my User email value being based on a Lookup? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 11, 2024, 2:15am UTC](https://community.glideapps.com/t/company-directory-app-users/69459/2 "2024-01-11T02:15:38Z")
You have your app set to Private. Which table are you using as your whitelist table? That whitelist table, and your user profile table in general need a basic email column to function correctly. On a side note, I do not recommend using Name to create relations. If a name ever changes, it will break relations. You should be using ID’s, which will never change. ---
**Author:** ![Brenten\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brenten_taylor/32/68533_2.png) [@Brenten\_Taylor](https://community.glideapps.com/u/Brenten_Taylor)\ **Post date:** [January 11, 2024, 2:22am UTC](https://community.glideapps.com/t/company-directory-app-users/69459/3 "2024-01-11T02:22:35Z")
The Company Directory has the basic email. But the whitelist should be the User table. The project mgmt app has a Choice in the app to add a user by pulling the name from the directory. But I can’t figure out how to write a basic email address into the User table, utilizing data from the directory. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 11, 2024, 2:57am UTC](https://community.glideapps.com/t/company-directory-app-users/69459/4 "2024-01-11T02:57:45Z")
Can you show screenshots of the Privacy configuration and the User Profile configuration? ---
**Author:** ![Brenten\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brenten_taylor/32/68533_2.png) [@Brenten\_Taylor](https://community.glideapps.com/u/Brenten_Taylor)\ **Post date:** [January 11, 2024, 2:40pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/5 "2024-01-11T14:40:18Z")
You’ve already stated that it needs to be a basic e-mail, which I also tested and confirmed to be true. I just can’t figure out a way for the app user to choose a name from the company directory collection and have the directory contacts e-mail written into the User table’s basic e-mail column. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 11, 2024, 3:04pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/6 "2024-01-11T15:04:57Z")
> [@Brenten\_Taylor](#): > > You’ve already stated that it needs to be a basic e-mail, which I also tested and confirmed to be true. Your Users table needs at least 3 basic columns and I would recommend 4 just to be safe: - Basic text for Name - Basic email for Email - Basic image for Image - Basic text for Role Then configure your User Profile screen accordingly. I’m not sure 100% that Name, Image and Role in the Users table need to be basic, perhaps they could be computed. Role is a restriction so it most probably needs to be a basic column. The Email column needs to be a basic column when your settings have a restriction on the email address (emails in a whitelist or restriction to a domain name). > [@Brenten\_Taylor](#): > > and have the directory contacts e-mail written into the User table’s basic e-mail column Wrong way. If the app is set to private or if there is a restriction on the email address, then the app will automatically write email addresses to the Email column in the dedicated Users table. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 11, 2024, 3:08pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/7 "2024-01-11T15:08:14Z")
> [@nathanaelb](#): > > I’m not sure 100% that Name, Image and Role in the Users table need to be basic, perhaps they could be computed. They must all be non-computed columns. ---
**Author:** ![Brenten\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brenten_taylor/32/68533_2.png) [@Brenten\_Taylor](https://community.glideapps.com/u/Brenten_Taylor)\ **Post date:** [January 11, 2024, 3:08pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/8 "2024-01-11T15:08:20Z")
OK I figured it out. When the app user selected a directory contact from the collection choice I realized I could write the value of the directory e-mail (rather than the directory contact name) into a basic email column in my User table and also continue to display the directory name in the collection choice. Now my user table is based on the e-mail address rather than the name. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/283eaf301460e9fc4f409844bc32a9bc7f1a12d5.png) Here is where I WAS passing the wrong value, and now it shows i’m writing the correct directory email address to the User table. This was really just novice user error. ---
**Author:** ![Brenten\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brenten_taylor/32/68533_2.png) [@Brenten\_Taylor](https://community.glideapps.com/u/Brenten_Taylor)\ **Post date:** [January 11, 2024, 3:16pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/9 "2024-01-11T15:16:58Z")
I can confirm that computed columns values do not work for user authentication log-in. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 11, 2024, 3:17pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/10 "2024-01-11T15:17:41Z")
It makes sense for Email and Role, maybe a little less so for Name and Image. But it’s true it feels a profile shouldn’t be computed on a device on the fly 🙂 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 18, 2024, 3:17pm UTC](https://community.glideapps.com/t/company-directory-app-users/69459/11 "2024-01-18T15:17:44Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.