Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Filter unique records in a field and populate into a new table

Topic Labels: Base design
Solved
Jump to Solution
1368 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey all!

I have a brand new base with some data that I imported in a CSV. It created a table called Classic Rock Songs (which is as awesome as it sounds) and populated records into 3 fields:

  • Song + Artist
  • Song
  • Artist

image

Each artist can have multiple songs (or at least the ones that were’t one-hit-wonders!), and I want to create a second table that:

  1. Lists all unique artists from the Classic Rock Songs table into the Artists table
  2. Links the records so that all songs for each artists show up in the Artists table

I’m basically struggling with the first step above, and how to create a new table with unique artists.

Appreciate any ideas… rock on! :guitar:

1 Solution

Accepted Solutions

Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.

See Solution in Thread

2 Replies 2

Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.

Thank you! That is very obvious now that you have explained it, much appreciated :slightly_smiling_face: