I am using Confiforms MatrixView to filter records in a form named as f grouped by filed f1 with filtered data (f2:2).
My question is that is there any way that I can only show f1 that have records associated. In the example below, when f2:2, f1 only has 2 records 2 & 3. However, the left menu shows all f1s anyway. Is it possible to only show 2 & 3 on the left menu?
Value f1:1 is in the database but I have the filter applied to the matrix view and the table view with f2:2 so the first record on the screenshot (f1:1 & f2:1) is filtered to be hidden.
In this case is there anyway to not show f1:1 on the menu? (since the tableview to the right doesn't have anything with f1:1 based on the filtered data.
Thank you again for your prompt response. I tried "relevant options" as well.
However, it will only show one checkbox (2 in the example below) instead of both 2 & 3 because that I limit the number of the records to be returned, which is needed for the tableview to only show once.
If I remove the limit 1 from the matrixview, then the tableview will show twice as shown on the screenshot below.
How can I show the checkboxes to the left without duplicating the tableview to the right?