Suggesting a Song(Item) based on 1 or more conditions

Hi Everyone,

So I am creating a 'Song Selector' App the create set lists for a band to play.  I would like AppSheet to 'suggest' songs based on 2 criteria, either the base note or 'theme' of the song.  Example a song can have the theme of 'love'.  How can I accomplish this?  Please see belowrelationships-appsheet.png

0 3 79
3 REPLIES 3

The easiest way is to use search functionality. Search from the Songs table view with these two categories. Would that be enough?

I will try this and get back to you... Thank for your replying

I wanted so that the only user input would be the first song in the list.. and then a list of other suggested songs pop up as suggestions, but I can try this method

Top Labels in this Space