I’m trying to serve a single thing of custom type “Song” to a user (for them to review) based on the first item of a list of songs, but the list needs to be ordered in a certain logic-based way (surely there’s some way to use AND/OR type logic, but i just can’t figure it out for the life of me!)
Each Song has a field called GenreProfile of custom type GenreProfile (another thing), and the thing GenreProfile has fields for 6 numbers and a Song (ParentSong). A Song also has a field called NoOfReviews which is a number that increases with each review.
Also each user has a field “GenreProfile” with the same type, where their genre preferences are stored (and ParentSong will be blank for those)
I want the list order to be decided partly by taste match, (:RankedBy similarity to Current User’s GenreProfile) but also partly by how low NoOfReviews is. And ideally I want to make this on a sliding scale, where if NoOfReviews is zero, it gets 90% weighting, and when NoOfReviews>10 then theyre ordered by GenreProfile Similarity alone.
And then I only want to return the 1st song in the list.
I can’t figure out how this might be possible, after trying lots of ways for about 2hrs now and reading a bunch of threads on here, but also i’m a noob so maybe i’m overlooking something obvious!
Thanks so much for anyone that can help. I’ve only been using Bubble for about 3 full days now, and am absolutely blown away by it’s power and the endless possibilities of what i hope to do with it!