Extract All Dates Linked to an Item

[Jason_F]

Hey Everyone:

I have a table that houses 260 records. Each record represents 1 Song.

I have a rollup in that table that has every date I have practiced that song in my set lists.

Set lists are individual records that track each show and adds the song in the position played.

I want to take that list of songs and the date rollups and create a new table that has all the songs listed one by one by date played.

I know moving forward I can do this by automation as the records are created, but how do I do it for everything in the past?

[Kamille_Parks · Accepted solution]

Use the same Automation. Add a checkbox field, adjust the Automation to run when record matches condition: “checkbox = checked”. Check all the boxes for your existing records, wait for the Automations to run, change your Automation back to whatever trigger you need, delete the checkbox field.

[Jason_F]

I think this almost works. The problem is that one song has multiple dates in the roll up associated with it.

So if song 1 is played one 10 dates I want 10 new records each with the name and the date.