Automation with text of another table: Cannot assing list of string to string

[milenicols]

Hello everyone, I need help with automation.

1. I have Table 1 with the primary field 'Date' where I receive in a column 'Complete Description' a long and annoying detail

2. I want to simplify step 1. based on the primary field of Table 2 'Expense' where I have a list of expense types.

3. So, when a record is created in Table 1 AND CONTAINS ANY OF THE WORDS from the primary field of Table 2 'Expense', I want it to be placed in the column 'Details' in Table 1.

How could I do this? I always get the error 'cannot assign list of string to string'."

[Sho]

Hi @milenicols,

What lists are you trying to update and to which fields?

Use Find Record to find only the records you need.
The results can then be updated as the value of a linked table field.

Read the reference for more information about Find Recods.

Find Records Automation Action | Airtable Support