I know I can use count to count the number of links that occur, but does anyone have a solution for counting the number of times the main column occurs in a link. So for this example here I’d like to have a column that tells be how many times a “Name” is used in the “Linked Skills” so it would be 0,1,1,0,3 for the cases shown here.
This works great!! Thank you for taking the time to build it out and explain it!! I’m using to being able to use PivotTable data from excel but that feature doesn’t seem to exist here, but this will work for what I need! Thank you!
If you had a two table system, Airtable would give you a “backlink” field that you could leverage to get this info. However, with same-table links, Airtable does not create backlinks.
Instead, you can use another same-table link as the “backlink” and setup automations to maintain the backlink field. Then you could use another “count” field.
Using a same-table backlink field that is set by an automation has some advantages:
it can scale better. When you have many records all linked to a single control record, it can slow down your base
it will work even if one record’s name is a subset of a different record’s name. For example, if you had a record named “step 1” and another record named “step 123”, the statistics for “step 1” would be off. (You can get around this by using a careful naming that avoids this situation or by using record IDs, but that complicates the system.)
with a backlink field, you can generate other statistics using rollup fields.