Here is what I did, I first use a relation column to relate the mood rate to a column with mood numbers, and there are multiple quotes with one mood number, and I want that, so the single value can pick one of the few quotes randomly from it each time:
And then I plug the single value column to the relation, but weirdly it returns all the quote instead of only display one random quote, here’s my configuration:
then because both the relation and the single value doesn’t show up as an option for the text I want to display, I used a lookup to try to display a quote, but sadly the lookup also didn’t show up:
This is what is happening, is there a way to fix this?