Hi !
Firstly, love what you did with Grist, I’ve been on it for only a few days and already in love
However, there’s something I haven’t figured out how to do : I want to display a table widget, but I want to select displayed records not by a direct field but by an indirect one.
Here’s my structure :
Events
Meals has a FK to Events
Recipes is linked to Meals through an association table recipe_per_meal (because I need additional columns of information)
Now, I’d like to display a table of my recipe_per_mal, not selected by current meal as suggested by the “select by” dropdown, but selected by current event (so, all the lines of my table recipe_per_meal that are linked to a meal itself linked to the selected event)
I tried with a formula column in my recipe_per_meal table, thiking I would then be able to select this formula column in the select by dropdown, but no success
Did I miss something ? Or is my approach wrong ?
Thanks a lot !!