Drewmyster
Board Regular
- Joined
- May 16, 2007
- Messages
- 133
This is something I’d really like the capability of doing via a spreadsheet, a formula (or I guess macro specifically), that is able to look up data from Spotify or Apple Music and return what would be classed as an artists “latest release” and also the date of the release.
Taking two examples;
Atist: Miley Cyrus (Artist(A1)), [Lookup latest release] returns “Plastic Hearts” (Title(A2)), “Album” (Type(A3)), “November 27, 2020” (Release Date(A4)).
Artist: Kylie Minogue (Artist(B1)), [Lookup latest release] returns “Real Groove (Studio 2054 Remix)” (Title(B2)), “Single” (Type(B3)), “December 31, 2020” (Release Date(B4)).
Is someone able to write a macro or show me how to do this?
Taking two examples;
Atist: Miley Cyrus (Artist(A1)), [Lookup latest release] returns “Plastic Hearts” (Title(A2)), “Album” (Type(A3)), “November 27, 2020” (Release Date(A4)).
Artist: Kylie Minogue (Artist(B1)), [Lookup latest release] returns “Real Groove (Studio 2054 Remix)” (Title(B2)), “Single” (Type(B3)), “December 31, 2020” (Release Date(B4)).
Is someone able to write a macro or show me how to do this?