- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 26, 2021 03:52 AM
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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 26, 2021 04:47 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 26, 2021 04:47 PM
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