Filter on front-end - add "contains" for rollup-field

The case: I have enabled filters on a table of candidates.
This is what is done in the builder:

Then I would like to filter on this field in the front-end/live app, where this is a roll-up field.
The filter in the table doesn’t recognize the field as a text-field, which is why contains is not shown as a possibility, as shown here:

But even when I match the exact company name in the filter, it shows no result.

It could therefore be:

  1. the filter function doesn’t work with roll-up fields
  2. the filter doesn’t recognize a roll-up field as a text field
  3. something else.
1 Like

There is a work-around:

  • Add an “equation”-field.
  • In the equation the only thing you add is the “roll-up field”.
  • add the equation-field in the table and add the equation-field in the search field in the builder
1 Like