Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Find records where multiple relation field contains a dynamic text errors

Topic Labels: Automations
405 2
cancel
Showing results for 
Search instead for 
Did you mean: 
  1. When a record matches conditions: Where relationship exists.
  2. Update record: Copy name of related record of the triggered record into plain a text field.
  3. Find records: Where multi relation field contains the dynamic value of the plain text field.

Results: An unknown error occurred. Filters: Invalid filter on [table]

I don’t know what I’m doing wrong, why this errors - suggestions appreciated.

2 Replies 2

Hi, Ricardo
multi relation field supposed to contain array of values, record IDs. even if it’s single ID, or no ID
it’s still array
“contains” suppose String 1 contains String 2, not array.
You can create additional formula field near multi relation field with CONCATENATE(‘multi relation field Name’). It will contain the same, but in a form of a string, and formula will work.

But I feel that your goal can be done even in more simple way, i just can’t realize your goal.

Thanks, I will try the concatenate option. :slightly_smiling_face: