Filter from other table

Hi. Is it possible to create a filter in an application builder table from a linked database table?

I have a table for users and a table for cases. I want to let application users filter cases based on the connected user for those cases in a application builder table, but the filter field seem to be inactive and unavailable:

Hi @patrick,

I’m afraid at the moment the following field types are not filterable:

  • Link to table
  • Created by
  • Modified by
  • Collaborators

We hope to improve upon them in the future, but at the moment you will see “Unavailable” when you hover over their checkboxes.

Cheers,
Peter Evans

Ok, thank you for the quick reply! Any workarounds for this? I tried to add a formula and a lookup field to duplicate the value to another field type but that didn’t work.

Hi @patrick,

I asked our specialist, @frederikdc about this, and he suggested that you create a rollup or formula field that converts the primary field (the first one on the left in your “Behandler” table) to a single text field. You can then allow logged-in users to filter upon that single text field from the application builder.

I hope this helps!

Cheers,
Peter Evans

Thanks for the suggestion. I couldn’t figure this out using a rollup or formula field, but I added automation using webhook and Make to duplicate the value from the link to table-field to a single select-field which I’m able to filter on in the application builder.