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