ReluctantlyOnlineIt’s music request month in my studio and my sticky note tracking system broke down. Ideas for organizing this that doesn’t involve learning a whole new task management program?
Lucas@SusanOML I mean this seems like the perfect opportunity for a vibe coding challenge haha. Do you write down the requests on the sticky notes yourself or are they handed in? I’m imagining just a dedicated webpage with stickies that you enter the text for.
@Lucas during lessons I write them as we brainstorm ideas. I tried writing them in Goodnotes on my iPad but that didn’t “stick” either. 🤓 this time of year is bonkers trying to track all the requests, music reimbursement costs, and fulfillment. I’m sure excel could do it…. But it’s so…. Boring?
@SusanOML haha as someone who uses excel a lot at work, I would also want a different solution 😂. Well feel free to request some features if you think this is neat, no pressure though I was just on the hunt for vibe coding requests/ideas to try it out.
@Lucas please ignore that I have no idea how to use GitHub and I bet this code is a mess, but here’s what I ended up with: https://susan-oml.github.io/music-request-tracker
@SusanOML I just looked at your github page again and saw that you made some updates to the music request thing! Are you using this now? Tested it out for kicks and the export to excel works great.
@Lucas well I got distracted realizing I could make music games - so I went on a vibe coding tangent. 🤣 Butni was able to implement the game in my studio website! Tomorrow I dig into the music tracker for real.
@SusanOML Well I similarly got distracted by someone else on here requesting a "record a 10 second saxophone line and output it as a musical notation" app. I'm actually getting some output on that but the notation isn't super accurate lol (yet I hope).
Well now you have to share the game on the website, come one!
@Lucas the music notation problem sounds intriguing and challenging. I had a heck of a time teaching Claude how to properly place a treble clef. Are you using harmonic frequency analytics and mapping to the staff?
@SusanOML What a great, easy to understand game, love it!
My current framework is actually using a library that researchers at Spotify publish called "spotify basic pitch" that transforms .wav into midi. Then another thing (I forget what) translates that midi into notation. I haven't had much time to properly test it (Snow days!) but I'm hoping if I tweak the quantizing I can get something useful
@Lucas are you notating the rhythm as well? It just pitch?
@SusanOML Rhythm and Pitch both yeah. It actually handles bass clef and treble clef rather nicely depending on the range (and I have a function in there for transposition vs. concert pitch on different instruments). At the end of the day though, if the notation doesn't match what's played, it's not going to be useful haha.
@Lucas got it. My ability to figure out GitHub makes me look much more technologically literate than I am. Makes sense now. This would be super useful as a music educator!
@SusanOML Being able to use github a huge leap on getting more technologically literate! I've always been a computer junkie, but I don't consider myself very tech literate compared to any software developer I've ever met.
@Lucas my husband has a phd in cryptography/comp science so he’s been very entertained by my messy code and discovery of GitHub. Never too late to learn something new, though! I’m so glad you nudged me into vibecoding!
@SusanOML lol well maybe he can look at my music transcriber repo when it’s done and tell me how inefficient it is 😂 my wife is a lawyer so she has no interest in examining the code haha.
@Lucas Hey, if you have questions, I'm sure I could ask him to poke around the code! Seriously - don't hesitate to ask!
@SusanOML Alright check this out, especially on mobile. I used what claude made for you as the basis and expanded on it (note the dark mode feature with the moon button at the top if the default hurts your eyes like it does mine):
https://lwassmer42.github.io/CodexMusicRequestMobileSite_App/#/home
@Lucas it looks gorgeous on mobile! I actually use my laptop for this kind of thing the most, though. It looks great there, too. I started to play around with what I want to have happen when a request is both delivered AND reimbursed. Do I want them archived? But it brought up a bunch of side cases, so I abandoned the idea. I'll play with it and let you know if I think of anything else!
@SusanOML a good point. Otherwise delivered would just be filled with hundreds of cards. At the very least there’s currently a filter, so when it goes to the next month you won’t see the “delivered” ones anymore from January.
Sure just let me know! If you get to the point where you might actually want to use it codex gave me some ideas on how to host it as a web app for free so you’d have storage and whatnot, Would be good practice for me.
@Lucas I ended up down a rabbit hole of possible cases where some items didn't have costs, some are only deliverable if they are reimbursed, what happens if boxes are left empty, un-archiving, and error handling for use cases. I threw up my hands. I think the filter by month is super.
I *really* appreciate your help on this! It's very kind of you!
@SusanOML It's been a bit! I've been busy with work/sick kiddos, but I finally have a new version for you test. You can now mark something as "only deliverable if reimbursed" and the UI enforces new rules. And there is a new "Archived" section that includes any records that are both delivered and reimbursed. If this looks good for a starting point, I think I have a good plan for hosting it for free.
https://lwassmer42.github.io/CodexMusicRequestMobileSite_App/#/home
@Lucas Hi! Sorry to hear about the sick kiddos! No worries. I've been buried in volunteer work for the local musical. Fun, but time-consuming!
This is so sleek-looking. Sometimes I deliver something but it isn't reimbursed yet. So I think I probably need something more like "if it's delivered and reimbursed, THEN it's archivable" if that makes sense.
@SusanOML right now the logic for a record/card is automatically:
Nothing or Reimbursed checked: stay in pending column
Delivered checked: move to delivered column
Delivered and reimbursed checked: move to archive
Sounds like maybe you don’t want things to automatically be archived, but have an “archive” button available when something is both delivered and reimbursed?
@Lucas Yes, I think you nailed it.
@SusanOML And I also want to point out that we're still very much in the bounds of Free. I'm on a free supabase backend and a free cloudflare pages plan. With just all of our stuff just being text at this point, it'll take 250k records/cards before we fill up the 500MB limit of the free plan
@Lucas I'm in the weeds, bookkeeping today, and the Music Request Tracker is saving me so much time! Thank you again!
@SusanOML No pressure whatsoever, but I got a message from Supabase that they'll pause the music request app for inactivity in a few days.
If you actually like it and want to keep using it let me know, otherwise I can just let them pause it/shut it down. All good either way :)
@Lucas Hi! So I use it for sure, but in bursts and then there are periods of quiet once everyone has music. (Everyone chose their spring recital songs!) I definitely don’t want it to be a hassle for you though.
@SusanOML Looks like they pause the free tier projects after 7 days of complete inactivity. Shouldn't be too hard for me or you to logon and make a small change once a week honestly. I'm fine with keeping it up and running. Or if you have any music teacher friends, try to get them to use it and we'd have at least 1 more person in the mix to keep us from inactivity :P.
@Lucas thanks a million! If okay, I’ll share in my online teacher circles. But at the very least I’ll be sure to log in each week.
@SusanOML For sure feel free to share, I really don't think even several people using it intermittently would cost us anything. The fact that you're using it and it speeds you up is amazing to me haha.
I still check the forkiverse, but not as much as I once did, so if you ever have any issues or questions you can message me here, but you'll probably get a faster response emailing me at [email protected]. Cheers!