Help

Grouping data by users

Solved
Jump to Solution
322 1
cancel
Showing results for 
Search instead for 
Did you mean: 
bartdubs
4 - Data Explorer
4 - Data Explorer

Hi there,

I would like to organise the data based upon each individual user in the linked lookup field on the right hand side. When grouping the data it groups all of the looked up fields together. Is there a way of sorting the data to be per every individual linked user. So each user has a set of this data.

bartdubs_0-1696856084790.png

Any help would be greatly appreciated,

Bart

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

You would only be able to do this by restructuring your entire base.

You would need to create a 3rd table which would then become a “many-to-many relationship”.

I will be creating a training video on this in the near future, but in the meantime, Airtable has a basic guide on ”many to many relationships” here:

https://support.airtable.com/docs/understanding-linked-record-relationships-in-airtable

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

You would only be able to do this by restructuring your entire base.

You would need to create a 3rd table which would then become a “many-to-many relationship”.

I will be creating a training video on this in the near future, but in the meantime, Airtable has a basic guide on ”many to many relationships” here:

https://support.airtable.com/docs/understanding-linked-record-relationships-in-airtable

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld