How to group by individual field (employee)

Topic Labels: Base design
935 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi All,

I am working on a work report / timesheet integration in Airtable. I currently have multiple tables

In the tasks table I will write in different columns the following:
Task description
Type of task
Project Number (from the projet table)
regular time
Employee (from the workers table)

Capture d’écran 2021-02-15 090227

I would like to be able to group the tasks by employees. There will be multiple employees working on the same task and currently the grouping will group all the employees together instead of individually. Is it possible to get the grouping to group each employees individually regardless of who worked with them on each of the tasks?

Capture d’écran 2021-02-15 090703

2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

Anyone has a solution to group a multi-select field individually?

You can’t group a multi-select field individually. You would need to convert your multi-select field into a linked record field instead, and then go into the OTHER table to sort your records there.