Skip to main content

Find records where multiple relation field contains a dynamic text errors

  • February 18, 2022
  • 2 replies
  • 26 views
Ricardo11
Forum|alt.badge.img+16
  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

Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • February 18, 2022

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.

Ricardo11
Forum|alt.badge.img+16
  • Ricardo11
  • Author
  • Inspiring
  • February 21, 2022

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:

Terms & ConditionsAccessibility statement