I’m wondering if Airtable could be used to manage a music collection. It needs to interact with Rocket Player (a music player I use on Android). Specifically:
Create playlists in Rocket Player - this could be as simple as creating an M3U file from an Airtable query, and dropping it in the file path where Rocket Player would see it.
Read the Rocket Player database (user trigger) to read in updated play counts and ‘last played’ date, and potentially other amended ID3 tags.
Read the Rocket Player database (user trigger) to query out any new songs added since last sync, and add them to the Airtable bases for artists, albums and songs.
FYI the main idea is for an Airtable query to suggest albums to play based on the ‘last played’ date with reference to a ‘rank’ value against the album. The various ranks would sit in another base where the play interval would be defined (in days).
Welcome to the community, @Julian_Wattam! :grinning_face_with_big_eyes: Airtable can definitely handle the music library management, but interfacing with Rocket Player will likely be the trickiest part. A quick search online didn’t turn up any useful info on accessing Rocket Player data, so you may have to write to the developers directly to ask if Rocket Player has an API that you can use. If so, you may be able to use tools like Zapier or Integromat to shuffle the data between Airtable and Rocket Player. If not, it will probably need to be custom code using Airtable’s own API.