Skip to main content
Question

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

  • May 12, 2018
  • 0 replies
  • 77 views
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 specific field in table 1?
    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement