Skip to main content

  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.

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.

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. 🙂

Reply


Terms & Conditions