Help

Updating fields based on matches within other fields

Topic Labels: Formulas
617 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kai_Gray
4 - Data Explorer
4 - Data Explorer

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,
Kai

0 Replies 0