Grouping data by users

[bartdubs]

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.

Any help would be greatly appreciated,

Bart

[ScottWorld · Accepted solution]

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