# Let each user mark his favourite items from menu **URL:** \ **Category:** Ask for Help\ **Created:** [April 12, 2021, 11:27am UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460 "2021-04-12T11:27:33Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 12, 2021, 11:27am UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/1 "2021-04-12T11:27:33Z")
I’ve got a sheet that has the menu, and a users sheet. I want to make a new feature in my app. I want to let user press a button or something like ‘Add to favourites’, and I want that specific item from the menu that the user added to his favourites, to be shown in his favourites column tab in Users. Im pretty sure that I need a ‘relation column’ in users sheet, but im not sure how to do it. If anyone can help me I would appreciate. Thanks in advance. ---
**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:** [April 12, 2021, 12:22pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/2 "2021-04-12T12:22:05Z")
You could use the built in favorites feature, which adds a column ‘isFavorite’, which is user specific. All you should need is the user sheet is a template column with the word ‘true’ and then create a relation column that uses template column and links it to the favorite column in the menu sheet. That will bring all the favorited rows into the user sheet and you can display them with an inline list pointing to the relation Or for simplicity, just add an inline list to the user screen that points to the menu sheet and add a filter where the isFavorite column is ‘true’. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 12, 2021, 12:24pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/3 "2021-04-12T12:24:28Z")
> [@Jeff\_Hager](#): > > cult in favorites feature Is this something inside the app? I mean should I tick something for that? Do you mean this? > **[Glide Docs](https://www.glideapps.com/docs)** > > Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build! ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 12, 2021, 12:32pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/4 "2021-04-12T12:32:15Z")
> [@Jeff\_Hager](#): > > You could use the cult in favorites feature, which adds a column ‘isFavorite’, which is user specific. I Have this. > [@Jeff\_Hager](#): > > All you should need is the user sheet is a template column with the word ‘true’ and then create a relation column that uses template column and links it to the favorite column in the menu sheet. Can you explain better these 2 columns that you are saying? I understand something like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/340e23fc20abb8ec7fee42c5ba5dbd4290607ca3.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:** [April 12, 2021, 12:44pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/5 "2021-04-12T12:44:44Z")
Yes, then you can create a relation pointing this “true” column to the “isFavorited?” column in the destination sheet. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 12, 2021, 12:50pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/6 "2021-04-12T12:50:11Z")
But thats a column that has everywhere true. Do I have to do something in the ‘replacemets’ below? At the template ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 12, 2021, 12:56pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/7 "2021-04-12T12:56:32Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d10560a66344b4393a0786f3649d26e7f12b6e81.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/a/8a012775aaa9a18a916b4be0c337419a1e0c0e24.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/9167a6c8c62dcac2709c4f0d02e2a94ba517375f.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/7320e342a256e00a560b3592125bf901d4224ee2.png) It seems like it added that for all of the users. not for a specific user ---
**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:** [April 12, 2021, 1:54pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/8 "2021-04-12T13:54:34Z")
It may look like it’s for all users, but the experience will be unique for each user. isFavorite is a user specific column. It should work just fine if you preview as different users. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 12, 2021, 4:35pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/9 "2021-04-12T16:35:09Z")
Thank you very much. If anyone need to do the same, you can follow the instructions. It worked for me. Thanks. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 13, 2021, 9:41am UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/10 "2021-04-13T09:41:37Z")
@Jeff_Hager @ThinhDinh ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55884dcd10b246143917f2195c8ab3c089f2a71e.png) Ive got a menu like this, and I want to make a new list, where the user can choose multiple products. So can I do it the way I did this topic? ---
**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:** [April 13, 2021, 11:57am UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/11 "2021-04-13T11:57:24Z")
What do you plan to do with the list afterwards? Is it like a cart? ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 13, 2021, 2:29pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/12 "2021-04-13T14:29:29Z")
Its like a page where the information of the user is sent to me via email. It is just a form. But I need to have the product that he ordered in this form too. I have to have column in the Users sheet that has the order. The order is from the menu sheet. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 13, 2021, 2:30pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/13 "2021-04-13T14:30:46Z")
I mean its already done for only ONE product. Its like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4dd2ab71f4ded3c12c0f4e886914f577c92e2ce1.png) ---
**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:** [April 13, 2021, 2:40pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/14 "2021-04-13T14:40:53Z")
Might be worth checking this out. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 13, 2021, 2:42pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/15 "2021-04-13T14:42:41Z")
Ive seen this before, so what is written in this ‘Blank’ sheet has to be written in my Users sheet? ---
**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:** [April 13, 2021, 2:50pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/16 "2021-04-13T14:50:37Z")
The only thing that’s really written to the Blank sheet is the unique id when the Clear button is clicked. This could be a User sheet if you wanted, or whichever sheet makes sense for your app’s flow. That unique id is brought into the task sheet using the single value column. Then whenever an item is clicked, it writes the unique id from the single value column to the selected column in the task sheet. If both ID’s match, then the item is selected. If they don’t match, then then the item is not selected. The relation and joined list in the blank sheet just pulls in the selected items from the task sheet. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 14, 2021, 9:18am UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/17 "2021-04-14T09:18:27Z")
Mr @Jeff_Hager can you explain a little more all these? And also, how is the parent ID generated? It is a text column, I didnt undestand it. ---
**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:** [April 14, 2021, 12:36pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/18 "2021-04-14T12:36:21Z")
If you look at the action for the Clear button, as well as the Start button, you will see that I am using a set Column action to write a Unique ID to the Blank sheet [https://docs.glideapps.com/all/reference/values/special-values/unique-identifier](https://docs.glideapps.com/all/reference/values/special-values/unique-identifier) Clicking on a list item is a custom action as also uses the Set Column action to copy the Single Column value (taken from the Blank sheet) in the task to the Selected column, or it clears it. Looking closely at the Actions should hopefully explain most of it. ---
**Author:** ![Marios\_Vasiliou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marios_vasiliou/32/16465_2.png) [@Marios\_Vasiliou](https://community.glideapps.com/u/Marios_Vasiliou)\ **Post date:** [April 14, 2021, 6:06pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/19 "2021-04-14T18:06:48Z")
So I need this ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/008a79b44f77ad31ffaef4f688c1a05353d1b5eb.png) To be at the Users sheet? So it is different for each user? ---
**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:** [April 14, 2021, 6:35pm UTC](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460/20 "2021-04-14T18:35:38Z")
Yes. Every time a Unique ID is generated, it is always a different unique value. The user will need to do something in the app where you can call a set column action to set that unique id. If that happens to be the user sheet, then yes, you can have that unique id on each user row. If it’s a different sheet, then that generated unique id can be placed into a user specific column in a single row, just like my example. Like I said. Which sheet you do that in all depends on whatever makes logical sense in your app. I don’t know how your app works, so it’s hard to say for sure. [Next page](https://community.glideapps.com/t/let-each-user-mark-his-favourite-items-from-menu/25460.md?page=2)