Help

Automation to auto categorize new records

Topic Labels: Automations
306 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Gustavo_VD
6 - Interface Innovator
6 - Interface Innovator

Hi everybody,

I'm trying to create an automation to auto-categorize new records based on a different Rules table.

This is what the Rules table looks like:

NAME  |  CATEGORY
Uber     Transport
Airbnb   Travel
Nike     Sports

 

And here's one example of a new record that needs to be matched with records on the above table and assigned a Category.

PAYEE              |    DATE     |     AMOUNT   |     CATEGORY
Uber Amsterdam         03/01          $40,00


I'm close to finding a solution, and this is my current automation:

Gustavo_VD_0-1682514068175.png

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.

 

Gustavo_VD_1-1682514068183.png
I grab all my Rules table so that I can iterate through it in the next step.

Gustavo_VD_2-1682514068666.png
I loop through my Rules table...

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

Gustavo_VD_4-1682514068415.png

 

Gustavo_VD_5-1682514068542.png

Update the record.

The problem is that the Update Record step throws an error in case the "Find Record" doesn't find a match..

Any hints about what could I do differently?

0 Replies 0