Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Base design
Solved
Jump to Solution
3103 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesse_L
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Kamille_Parks
16 - Uranus
16 - Uranus

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

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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: