# Show recommended values based on previous multi-selected values

**URL:** <https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259>\
**Category:** Ask for Help\
**Created:** [June 4, 2020, 1:39am UTC](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259 "2020-06-04T01:39:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![karldelacruz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karldelacruz/32/8477_2.png) [@karldelacruz](https://community.glideapps.com/u/karldelacruz)\
**Post date:** [June 4, 2020, 1:39am UTC](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259/1 "2020-06-04T01:39:45Z")

</div>

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

---

<div class="post-metadata">

**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:** [June 4, 2020, 1:45am UTC](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259/2 "2020-06-04T01:45:00Z")

</div>

It would be very nice to do this, and this is doable in my opinion. Just needs to have a good setup of individual ingredients, the template column to join all those chosen and do a lookup.

The tricky part would be the relation - lookup as people’s choices may not be, let’s say, in alphabetical order all the time. And the template column to join ingredients available for each dish is a challenge as well.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 6, 2020, 5:22pm UTC](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259/3 "2020-06-06T17:22:23Z")

</div>

A simple setup would be to create, let’s say, 10 columns set up in an array formation (Ingredient 1, Ingredient 2, Ingredient 3, etc). This will create an array column of Ingredient in glide. You can then create 10 choice components that will fill each individual ingredient column. You can then use the array Ingredient column for a relation to the recipes sheet which would also have an array of all ingredients listed. I think this should give you list of all recipes that match the ingredient list you entered. You can either display as an inline list or create a button that should allow you to set the relation for the link to screen action to show a list of matching recipes. I’m not entirely how or if this will all work as expected, but hopefully it gives you some ideas for the layout of your app.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 7, 2020, 3:10am UTC](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259/4 "2020-06-07T03:10:12Z")

</div>

This might give you some further ideas with a similar idea.

> [@User profile: select category from a list](https://community.glideapps.com/t/user-profile-select-category-from-a-list/10404/7):
>
> I would probably create a column for each category in a user profile sheet to hold a value from a choice component (up to 10 choice components). Each column would be set up as an array (Category 1, Category 2, Category 3, etc.) to create an array column of Category. You could use the category array column for a relation to the related articles. You could do this with checkboxes too if you created 10 checkboxes and filled 10 checkbox columns in the sheet for each user profile record. You woul…

---

<div class="post-metadata">

**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:** [June 7, 2020, 3:14am UTC](https://community.glideapps.com/t/show-recommended-values-based-on-previous-multi-selected-values/10259/5 "2020-06-07T03:14:26Z")

</div>

Hopefully I will have time to turn this into a video/GIF to illustrate it. Thank you Jeff!
