Hi Everyone! I am trying to show in my app 3 different weekly meal plan: 1 omnivore, 1 vegetarian and one vegan. In my data base I have: 1 tab Recipes - with the list of all the recipes and 1 column Day to indicate which day it is for. 1 tab My plan - the list of the days and some Multiple relat…

When it comes to relations, it’s almost always doable :wink: Real quick, by “day” do you mean a sequential Day number (Like Day 1) or weekday (like every Monday)?

ooooh that’s good news :slight_smile: Just Day number :slight_smile:

Cool, here’s how: add a column in the recipes sheet for type (eg Vegan). In the Glide Data Editor, create a template column that concatenates the Day and Type (eg Day1-Vegan) In the My Plan Sheet, you’ll need to create an identical template column. I imagine the ‘type’ is a value that lives in the…

Nice one! Let me try this out and tell you how it goes :slight_smile: thanks a lot for the quick answer @Robert_Petitto

@Robert_Petitto just one question, Is your step 2 to be done in the Recipe sheet or My plan sheet?

It needs to be done in both sheets, but specifically I was referencing the recipes sheet in step 2

Does that change something if Recipes can have multiple “types” and multiple “day”?

Each recipe/day/type should be on its own line, then it will work as intended. How is it currently set up?

YEs it is :slight_smile: But 1 recipe can be shown in multiple days, and multiple types of plan. Because a recipe for a Vegan works just fine also for an omnivore. And in the weekly plan, that recipe can be for lunch both on Monday and Friday for instance

I see. So a vegan should only see vegan but an omnivore can see vegan, vegetarian and omnivore recipes?

Relation multiple factors

Ask for Help

Robert_Petitto June 7, 2021, 6:20pm 17

Hm…you could be right…maybe I was thinking of the inapp filter / array column functionality about this very concept:

Topic		Replies	Views
Multi Filters using Relations: a new way 💡 Ask for Help	29	3650	May 6, 2025
Show recommended values based on previous multi-selected values Ask for Help	4	686	June 7, 2020
Creating Relation with a Relation and Column Ask for Help	7	850	January 17, 2024
Email filtering in inline list Ask for Help	14	632	February 4, 2024
Filtering data per record Feature Requests	9	813	March 27, 2020

Relation multiple factors

Related topics