Grouping data by users

bartdubs · ‎Oct 09, 2023

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 · ‎Oct 09, 2023

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

ScottWorld · ‎Oct 09, 2023

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