Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create a view with partial (but closes) matches from 2 differents tables

Topic Labels: Formulas
107 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all!

Would it be possible to use Airtable to find partial (but closes) matches in 2 differents tables (specific cells) and show the associated lines data?

Ex.

In table 1, in the choosen column for this query, there is a cell with ‘behind the word mountains’
In table 2, in the choosen column there is a cell with ‘behind words mountains’

I would like to have a view of the datas of both lines from both tables, when cells match partially.

1 Reply 1

Welcome to the Airtable community!

One way to accomplish this is with a junction table that is populated by a custom script. Creating the junction table is straightforward. Create a new table with two linked record fields, one for each original table.

Figuring out the script to identify matches is much harder. Not only would it require someone familiar with scripting, it requires a method for determining what constitutes a partial match. While there are coding libraries that help with identifying fuzzy matches, you cannot use coding libraries in scripting. Thus the logic needs to be built in the script. For example, do you want a strict number of words in common? Or a percentage of words in common? How close to words need to be to each other—would “books” and “booked” be close enough?