Check if the value exists in another table and ..

[Magic_User]

Hello,

I'm new to Airtable and I have a question.

I have 2 tables:

The first table collects data from influencers.

The second table checks via Instagram Integration whether there are new posts in which we have been tagged.

The first table should check in the second table whether an entry exists.

I imagine it like this:

Check if the value of the Instagram Username cell (Influencer table) appears in the Username column (IG Mentions table).

If yes, then output the value of the cell Permalink (table IG Mentions) in the cell Mentions (table Influencers).

How can I do that?

Thanks!!

[kuovonne]

Have you looked into Airtable's Automations? This sounds like a "Find Records" action followed by a conditional update record action.