[Airtable] Template: Find partial matches between tables

Let's say you have a table where each record contains text you want to find matches for like this:

And so whenever a new string gets added to your base, you want to check if that new string contains any of the text in the table above, and if it does, link them together:

This template helps you do exactly that, and you can test it before buying it!

First, check out the view of all the text that we're searching for: Text to find view
Then, check out the view of all the strings that we want to do the search through: Strings view
Finally, submit a new string to search through via this form: Form

The automation will take anywhere from 1-15 seconds to trigger, so please refresh the page if you don't see any changes! You will be able to see whether the automation has ran via the "Checked" field; once the automation has ran the "Checked" field will be marked.

Here is an example: