Skip to main content
Solved

Extract All Dates Linked to an Item

J

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?

Best answer by Kamille_Parks11

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.

View original
    Did this topic help you find an answer to your question?

    2 replies

    Kamille_Parks11
    Forum|alt.badge.img+15

    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.

    J
    • Jason_F
    • Author
    • Known Participant
    • 25 replies
    • June 9, 2021
    Kamille_Parks11 wrote:

    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.


    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.

    Reply


    Most helpful members this week

    Terms & Conditions