Need assistance with data migration from audio files to playlists

Hello Bubble community,

I’m currently working on restructuring my database in Bubble, and I could use some guidance on how to perform a data migration task. Here’s the scenario:

I have two data types in my app:

  1. AudioFiles: Contains information about audio files, including a field called “playlists,” which is a list referencing playlists associated with each audio file.
  2. Playlists: Stores information about playlists, including a field called “audioFiles,” which I want to populate with references to audio files instead of storing playlists within each audio file.

Here’s what I’m trying to achieve:

  • Current State: Each Audio File has a list of playlists stored in its “playlists” field.
  • Goal: Each Playlist should reference the audio files associated with it, stored in the “audioFiles” field.

I’m looking for assistance in creating a workflow to migrate the data from the “playlists” field of Audio Files to the “audioFiles” field of Playlists. Specifically, I need help with:

Any advice, suggestions, or sample workflows would be greatly appreciated!
Thank you in advance for your help.
Best regards, Al

I was able to figure this out by watching this video: