Forum Discussion

BrieonaCorneliu's avatar
BrieonaCorneliu
Qrew Trainee
8 years ago

How do I take an email field in one table to write a look up and based off that create a formula?

How do I take an email field in one table and write a formula to say: If the email field in this table matches the email field in table two, then copy the data from table two, and place it into a spec...
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
The way this is done in Quick Base is via a relationship and lookup fields.  But to look up data from table 2 into table 1, you will need to be able to set the Key field of table 2 to be the email field.

The email  field in table 2 will need to be unique and non blank in order that Quick Base will allow you to change the key field to be the Email field.
BrieonaCorneliu's avatar
BrieonaCorneliu
Qrew Trainee
8 years ago
Okay so I currently have table one set up
so it has 
email
field 1
field 2
field 3

then table 2 
has 
email 
field 1
field 2
field 3

email, field 2 and field 3 are look ups and then field one is a text reference field.

How do I create a formula that says  if email in table one matches email in table two then write that "number" into field 1, instead of it being a text reference? 

I wan't it to automatically write this information based off the given data, so I don't have to go through each one and select the matching/related "id".