Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Find records where multiple relation field contains a dynamic text errors

Topic Labels: Automations
1235 2
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect
  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: