Search Long Text field for string matching record in a linked Table

Hello @Stu_Smith, I have created an Airtable template for just this purpose and you can purchase it on Gumroad here

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 1-15 seconds to trigger, so please refresh the page if you do not 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:

Hello @Stu_Smith, I have created an Airtable template for just this purpose and you can purchase it on Gumroad here

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 1-15 seconds to trigger, so please refresh the page if you do not 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:

Ok. I purchased this as I've not had any other suggestions yet and it just gives me read-only access to your table... no instructions or anything on how to implement this into my own table. Can you help me out here?

Hello Stu, thank you for your purchase!  I have emailed the instructions to you and am more than happy to answer any questions you might have!

Hello @Stu_Smith, I have created an Airtable template for just this purpose and you can purchase it on Gumroad here

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 1-15 seconds to trigger, so please refresh the page if you do not 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: