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).