Group filter by formula

so simple my question is i have projects / task database
so i have checkbox in the projects either active or not active …

so is there a way to see task database grouped by active project even if the project doesnt have any task ??

because when i include empy groups = it will include all projects active and not active … and i want to see the active projects from task database so i either create tasks or so …

You can check if projet have no task or project have task and task activate exist

currentValue.tasks.isBlank() || ( currentValue.tasks.isNotBlank() && current.Value.tasks.filter(active).count() > 0 )

Where do i put this??

Hi @SALEM_MALIBARY

I did some tests here and it seems this is not possible to achieve.
When grouping by project and enabling the “show empty groups” option, all projects will show up — even those where the active checkbox control is disabled.
I tried filtering the table and also adjusting the options in the project relation column, but the grouping ignores these settings and still shows all rows from the project table.

I believe this might be a bug, as the grouping should follow the available options defined in the relation column.

Cheers
Arnhold

1 Like