Automation to auto categorize new records

Hello @Gustavo_VD , 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:

Hi @Lom_Labs , thanks for sharing your template. Impressive stuff.

I'm close to finding a solution, so I can't justify buying your ready solution. For me, it's also part of the fun to try and solve the problem.

I changed my automation to the following:

Basic trigger to watch for new records. I'm thinking about changing it to When Record Updated. Because when the record is created, the fields are still empty, so it doesn't find a match.

Then, I grab all my Rules table. So I can iterate through it in the next step.

And finally, I loop through my Rules table.

I find the records that match: newly created record_ID (I just want to update the new record) AND where the Payee column matches the record in my Rules table.

And finally, update the record.

The problem is. I can't find a way to test if the previous "Find Record" returns any record. So the following action, Update Record" errors because Im trying to update it with an invalid variable.

Any hints about what could I do differently?

I'm still struggling with this automation. Does anyone have any idea about how to get closer to what I'm trying to do?