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'."
