Database Linking Loop

Hoping you can help me work through this issue. I feel a bit silly running into a problem so early after having used Adalo successfully in the past.

Hi Tanner @tannerocampbell,

On 2:05 at your video you’re assuming that the you’re passing not only the Current Audiobook but also Audiobook Chapters, but that’s not correct - no “Chapters” are involved.

On the “Player” screen you have an access to Current Audiobook record with all its data, but Chapters are located in the separate collection so they are not a part of Current Audiobook record.
In order to get an access to Chapters you need to create a list of them, filtered by Current Audiobook → Chapters (and this is what you did).

But as your AudioPlayer needs a data from a certain chapter, you need to have an access to “Current Chapter” record. This can be achieved in various ways:

  • you can add a separate screen for Player, so you’ll have the flow of 3 screens: Audiobook Screen → Chapters Screen w/chapters list of current audiobook → Player screen with current chapter.

  • you can put the AudioPlayer inside Chapters list (make it a custom list). So Audioplayer can have an access to Current Chapter.

  • you can store the URL of a chapter (+chapter name, etc.) in some auxiliary properties (e.g. Logged-In User → Selected Chapter) and update these properties by clicking on a certain chapter from the list. AudioPlayer can use these properties as a datasource. It might be a good idea “reset” these properties before going to the chapters screen (write empty values there).

Of course this is a rough overview of possible solutions. For ##2,3 you’ll need to check if solution is working correctly in a native app - e.g. I’ve seen cases when multiple audioplayers didn’t work.

Hope this helps.

Best,
Victor.