- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 28, 2023 06:42 AM
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'."
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 29, 2023 02:06 AM
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.