Let's say I have a database of Singers, and another database of Karaoke Songs.
Here's the songs: https://www.seanarenas.com/songs
Here's the singers: https://www.seanarenas.com/karaoke-singers
I'd like to have a page where I can, as an Admin only, select a singer, then add a song to their list to sing.
When they're done singing it, I'd like to mark it as Sung.
When I select their ID later, I'd like to see what songs they've sung, and how many times, and the last date they sang it.
Then, there should be a client-facing page which lists all of the upcoming songs in the system. If I have 1 song for me, 2 songs for Vaughn, and 2 songs for Christel, they should see a table that shows:
Singer Next Song Next Next Song
Sean "Rapture" by Blondie
Vaughn "Californication" by Red Hot Chili Peppers "Enter Sandman" by Metallica
Christel "Metro" by Berlin "I Kissed a Girl" by Katy Perry
That page can go here: https://www.seanarenas.com/karaoke-lineup
Then the singers can look up that list on their phone or I can display it on the screen between songs.
The song database is already built, the singer database will be built real-time as new singers show up. What's my next step for developing this cool tool in Wix?