Need to create a unique email in each organization

Ask for Help
1

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?

2

Any chance of both the tables having a common column?

3

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?

4

yes

5

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

6

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.

1 Like