Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Updating fields based on matches within other fields

Topic Labels: Formulas
191 0
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

Thanks for looking at my question. Here’s what I’m trying to do:

I have multiple Tables in a Base; “Primary DB”, “DB2”, “DB3”, etc…

Inside of the “Primary DB” there are two Fields called “Company Name” and “Other DB”. The “Company Name” field is populated with … company names.

In all the other Tables I have one Field called “Company Name”.

I would like to create a formula in the Primary DB table / Other DB field that checks the values of the "“DB2” table / “Company Name” field, and if the values match, to fill in the Table name (“DB2” in this example).

And then for “DB3” and so on.

Is this possible?

Many thanks,

0 Replies 0