Skip to main content

The current summary stats for linked record fields are only Empty/Filled/% Empty/% Filled. Would love to be able to calculate Unique (in particular when you cannot link multiple records). 

A fictionalized use case:

I have two tables: a list of contacts and a list of companies. Each contact has a linked record to a single company. I would like to be able to see a count how many companies are represented by a filtered group of contacts -- either in the data view or in an interface. A workaround would be to go to the companies table, and filter to companies that are linked to a contact.

However, sometimes I only want to calculate this for a subset of contacts. Currently the best solution (to my knowledge) would be to create a roll-up field in the company table that counts linked contacts who match the relevant criteria and count the number of contacts using this formula.

Hey ​@queermath,

I’ll go through this again in a while to see if it can be solved by using a workaround. Regardless of that, do note that you will want to use this form to make feature requests!

 Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel

It turns out I was over-complicating my workaround -- I can use COUNTA as the roll-up function in the company table to count contacts who meet a certain criteria. Still -- would be useful to count unique linked records from the contact table itself (or within an interface that summarizes information about the contacts table).

Lol, yes that will work! Thanks for sharing your final solution :D

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel
 

Terms & ConditionsAccessibility statement