Hello everyone, which form field type would you recommend for the following use case? I would like to classify customers, where one customer can have multiple classifications. The classifications should be selectable via a multiple checkbox, so that, for example, a customer can have classifications A, F, and G. On the corresponding report page with the report table, I would then like to be able to filter, e.g. to show all customers that have classification G. Currently I am working with "Choice list".
But in the report, the column creates a separate filter for each combination of entries. For example, for a customer who has classifications A and B, it creates its own filter that must be selected, just as it does for a customer whose classification column contains B and C. However, when I set the filter, I then have to choose whether to show customers who have A and B or B and C. Is there a way to implement this more simply?
For example, is there the same checklist-style selection available on the report page as well, so that the user can also filter there by selecting one or more checkboxes to decide which customers should ultimately be displayed?
Thank you in advance for your ideas!
Regards,
Matthias