Skip to main content

Check if a cell value exist in another table

  • August 27, 2018
  • 3 replies
  • 69 views
A
  • Anonymous

Hello Community,

I have a table_1 with root domain urls (ex : cnn.com) and i’d like to do a check for each row in order to see if :

a) i’ve never contacted the website
b) i’ve already contacted and got a positive answer
c) i’ve already contacted and got a negative answer

I have a table_2 with the contact history

Is it possible to automatically check for a value in table_2 and based on that display something in table_1?

Many thanks for your help.

    This topic has been closed for replies.

    3 replies

    N
    • Noel_Howell
    • Known Participant
    • August 27, 2018

    Hi, So this is completely straightforward.

    First, on the contact history table, convert the url column to ‘Link to another record’ and then choose the ‘domains’ table. Airtable will automatically convert the ones you’ve contacted to their links. It will also and add a handy ‘Contact History’ column to the Domains tab showing the link! (Plus, It will also automatically create records at the bottom of ‘domains’ for anyone you may have missed.

    Anyone you have never contacted will have no linked records on the ‘Domains’ tab in the new ‘Contact history’ column.

    Also on the Domains tab, add a column for a ‘lookup’ where you will choose the outcome from the ‘Contact History’ table.
    :call_me_hand:

    A
    • Anonymous
    • August 28, 2018

    Wow @Noel_Howell looks just great ! I’m going to test it :slightly_smiling_face:

    A
    • Anonymous
    • August 28, 2018

    Wow @Noel_Howell looks just great ! I’m going to test it :slightly_smiling_face:


    It works like charm ! Thanks again

    Terms & ConditionsAccessibility statement