# Need to create a unique email in each organization

**URL:** <https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264>\
**Category:** Ask for Help\
**Created:** [November 16, 2022, 7:37am UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264 "2022-11-16T07:37:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Swetha67](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Swetha67](https://community.glideapps.com/u/Swetha67)\
**Post date:** [November 16, 2022, 7:37am UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264/1 "2022-11-16T07:37:29Z")

</div>

Hey ,

I have two sheets, Users and Organizations.

In each organization, I need to have only one unique user by email.

Can anyone help me?

---

<div class="post-metadata">

**Author:** ![Sumer\_Bhadra9](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sumer_bhadra9/32/36080_2.png) [@Sumer\_Bhadra9](https://community.glideapps.com/u/Sumer_Bhadra9)\
**Post date:** [November 16, 2022, 8:10pm UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264/2 "2022-11-16T20:10:10Z")

</div>

Any chance of both the tables having a common column?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 16, 2022, 9:43pm UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264/3 "2022-11-16T21:43:35Z")

</div>

So you’re saying that a user can’t be assigned to more than one organization in your app? It’s a 1-to-1 relationship?

---

<div class="post-metadata">

**Author:** ![Swetha67](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Swetha67](https://community.glideapps.com/u/Swetha67)\
**Post date:** [November 17, 2022, 6:00am UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264/4 "2022-11-17T06:00:30Z")

</div>

yes

---

<div class="post-metadata">

**Author:** ![Swetha67](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Swetha67](https://community.glideapps.com/u/Swetha67)\
**Post date:** [November 17, 2022, 6:01am UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264/5 "2022-11-17T06:01:08Z")

</div>

yes we are storing the org Id in the both the sheets

---

<div class="post-metadata">

**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:** [November 17, 2022, 6:25am UTC](https://community.glideapps.com/t/need-to-create-a-unique-email-in-each-organization/54264/6 "2022-11-17T06:25:56Z")

</div>

Then you should be able to create a single relation in your Org table that matches the OrgID to Users-\>OrgID, and then use a lookup to fetch the associated email address.

But, a question… do you plan to use that as a Row Owner column? If yes, that won’t work. You would need use a basic (non-computed) column and populate it some other way. ie via an onboarding process or pre-populate it.