Skip to main content

We have a requirement like below.

e.g.

Consider a table with column as Names.

Names

abc

xyz

abc

pqr

pqr


We want two columns in another table as below.

UniqueNames NamesCount

abc 2

xyz 1

pqr 2


Is there any way to achieve this?

Hi,

Yes, that’s also a nice demo of link creating logic in airtables (link to existing record, and if not, create and link):



  • create new empty table2

  • in table1, add linked field to table2

  • copy-paste Names (whole column) to linked field

  • in table2, add count field to linked

    that’s all

    to perform cleanup, you could also:

  • (table2) convert count to text, delete records where linked field is empty,

  • (both) remove linked fields


Reply