Roll Ups for Fields Linked Within The Same Table

[Constance_Brown]

I have a table where the linked fields are references to other rows in the same table. I want to create a roll up field, but this isn’t allowed because the links aren’t to another table. Would it be possible to remove this restriction?

[Sean_O_Shea]

Thanks for the tip about copying the base. I’m not asking anyone to write up a wiki—just to edit a few links in the same spirit of helping others that prompted them to put in the work to begin with. Linking directly to the answer with the solution would help community members benefit from their hard work and contributions, instead of going down a link rabbit hole and possibly not finding the right page.

[William_Nutt]

Bewildered as to why this would not be a feature. Please implement!

[Seongji_Kim]

This is a must! The concept of Airtable is great, but I’m starting to experience that it is definitely lacking some of these essential features we need to be able to take a full advantage of the platform. I don’t imagine this is such a difficult feature to add. Please add this feature! :pray: :pray: :pray:

[Dharamveer_Sing]

W_Vann_Hall:

demonstration base

So, I should probably make a copy of the same table and then link up to it :man_shrugging:

[W_Vann_Hall]

Dharamveer_Singh_Cho:

So, I should probably make a copy of the same table and then link up to it

That sounds as if it would next to impossible to maintain. Instead, I was talking about an all-to-one link from every record in your main table to a single record in a second table. This post and referenced base goes into much more detail about the technique and potential uses.

Multi-record calculations (c.f. 'running balance,' 'row number,' and the like) Show and tell

tl;dr version: A frequent query and/or complaint concerns users who wish to access data from a record for use in a calculation performed in a different record from the same table. Often this takes the form of a user asking ‘how to retrieve a value based on row number’; other times the user wishes to perform a calculation that assumes knowledge of the previous record — for instance, maintaining a running balance. A recently published base contains four approaches to this problem, three involving …

[Katherine_Duh]

Hi everyone! Lookup, rollup, and count fields now support looking up, rolling up, and counting from a linked record field that has been linked to its own table. This will make it easier to model the relationships between records that exist in the same table. Going to go ahead and set a timer for this thread to close—thank you all for your patience, and happy linking!