# Best Practice For Nutrition App **URL:** \ **Category:** Ask for Help\ **Created:** [July 8, 2020, 11:04pm UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189 "2020-07-08T23:04:18Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 8, 2020, 11:04pm UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/1 "2020-07-08T23:04:18Z")
Hello everyone. Before I get started on my next phase, I was wondering if some of you could give me some tips on the best way to link spreadsheets together for my nutrition app. I’m not sure if I should use filters or relations. Check out the image of a simple diagram because one of the options, I could add the list of foods on the same sheet which might make it easier. Would love some input please… thank you! ![AWC Food & Recipe Example](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/39180890b5ab1aac812dd9a4d9c3ac399bda1e1a.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 8, 2020, 11:25pm UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/2 "2020-07-08T23:25:24Z")
In the link between sheet B & C, let’s say Vitamin B1 Foods have Beans, Peas, Lettuce for example. Does it have to be a complete match to return the “Healthy Bean Salad”, as in if the salad has eggs for example, will it be returned? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 8, 2020, 11:35pm UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/3 "2020-07-08T23:35:42Z")
It is ok if the salad has other ingredients because that will become a choice for the user to make. However, there will be a feature for the user to choose Vegan which will filter out any recipes that have animal products so then, they would not see a salad containing egg. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 8, 2020, 11:48pm UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/4 "2020-07-08T23:48:35Z")
In sheet B, do you plan to store all types of food for a vitamin in only one cell, or will there be different rows? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 9, 2020, 12:04am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/5 "2020-07-09T00:04:56Z")
As of right now, it is all in one cell with the foods separated by a “,” Example: Avocado, sweet potato, spinach, edamame Would it be better if each food was in it’s own row / cell? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 9, 2020, 12:12am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/6 "2020-07-09T00:12:17Z")
How many types of vitamin do you plan to have for sheet A? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 9, 2020, 12:23am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/7 "2020-07-09T00:23:39Z")
23 total ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 9, 2020, 1:06am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/8 "2020-07-09T01:06:57Z")
What do you think if in the Recipes sheet, we pre-populate some columns that this recipe correlates with which vitamins? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 9, 2020, 1:19am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/9 "2020-07-09T01:19:45Z")
There are over 4 thousand recipes and I don’t have that kind of time. The assessment shows the top foods that contain those vitamins. So all I need to do is have the app find those foods and display the recipes. It will be up to the user which ones they want to eat. There will be another filter here as well that will find recipes based on the users skill level in the kitchen. Example: easy recipe or quick recipe ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 9, 2020, 1:31am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/10 "2020-07-09T01:31:22Z")
> [@Derek](#): > > So all I need to do is have the app find those foods and display the recipes. This is the tricky part, we have to have a design that links the foods that contain the vitamin to the recipe. The recipe may contain just some of the food types, not all of them. A while ago there was a talk about having some kind of a “What do we eat today?” with the requirements that the user list what types of food they have in the fridge, then recipes would come up to suggest what they should cook. The same problem applies here, it’s a partial match not a full match. To have a partial match working I think you must have those food types in sheet B in separate cells, either by multiple rows or multiple columns. ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 9, 2020, 5:20am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/11 "2020-07-09T05:20:14Z")
FYI: It is ok for it not to be an exact match because recipes have many ingredients. It is up to the user to decide if they want that recipe. So, it does not matter if the recipe only contains some of the foods. So, you can’t search one cell that has a list of a bunch of foods? If that is not possible then I can do columns with the name of the vitamin/nutrient in the header and then list all the foods below. Would that work? ![Screen Shot 2020-07-09 at 3.19.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a5308f75e2a758ab313ecfe52e53ac47b7791718.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 9, 2020, 8:53am UTC](https://community.glideapps.com/t/best-practice-for-nutrition-app/12189/12 "2020-07-09T08:53:42Z")
> [@Derek](#): > > So, it does not matter if the recipe only contains some of the foods. I mean matching partially is harder than matching the full package. You might find some idea from this. > [@Show recommended values based on previous multi-selected values](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259): > > Hi lovely people of Glide, Im thinking of creating an app where I can choose multiple values and then click next where I can see recommendations based on my selection. E.g. Cooking app where I can select first the ingredients and then it will show me the recommended dishes based on the ingredients I selected. Regards, Karl