# Brain picking - members area **URL:** \ **Category:** Ask for Help\ **Created:** [May 31, 2020, 3:26pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092 "2020-05-31T15:26:09Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 3:26pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/1 "2020-05-31T15:26:09Z")
Hi gliders, I want to pick your big brains if you let me šŸ˜ Iā€™m building a guide for no code tools (glide included obviously) in glide. Some of the guides are open and free to all and some are for members only. I have a hard time to allow members only the authorization to view all 2hile the rest could go only to the open part. I figured out a way to do it with creating separate lists but itā€™s not very user friendly. Has anyone built something like this before and have an idea how to do it? I have in my guides sheet a column that indicates if the guide is for members only or open to all but canā€™t use this on the filter as the row doesnā€™t belong to a specific user. Any ideas in how to attach this in a nicer more friendly way are much appreciated. The app itself will eventually allow building a costume guide that looks different for each guide based on playing with multiple components and filling part of them do the look will be different. Thanks hive brain! ---
**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:** [May 31, 2020, 3:34pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/2 "2020-05-31T15:34:08Z")
If you are using user profiles, you should be able to indicate what kind of member each user is and use that for the filter of your list of guides. Or do you want all to be viewable, but only certain ones have access to more details? I think this is a pretty good representation of what you can do. > [@Tutorial for paid memberships with Zapier & Memberful](https://community.glideapps.com/t/tutorial-for-paid-memberships-with-zapier-memberful/7877): > > Just finished a video tutorial on how to monetize your app with paid memberships using using Glide, Zapier, and Memberful which I noticed a lot of people were asking for here in the community. The tutorial is for a recipe app, but you could use this logic for any type of app with premium content. There are 6 lessons and it takes about an hour to go through. [You can access the tutorial here at nocode.mba/courses/allrecipes](https://www.nocode.mba/courses/allrecipes) The tutorial includes: Building a recipe app Adding the ability to offā€¦ Also, the category you selected for your post is intended for solutions only, to refer people to. Not so much for asking question. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 3:57pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/3 "2020-05-31T15:57:19Z")
Yes. I want all to see everything but only paying members to be able to see the details screen. Thanks for the help and for pointing my category. Changed 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:** [May 31, 2020, 4:03pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/4 "2020-05-31T16:03:41Z")
I think you might have to let them click through to the details, but then use visibility to hide any components you donā€™t want them to see. I think thatā€™s what was done in the tutorial I shared. If you let them click though to the details and itā€™s a paid area, you could display a purchase button and maybe a teaser description, but hide the rest until they are a paid member and their status changes in the user profile sheet. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 4:37pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/5 "2020-05-31T16:37:46Z")
I thought about doing it like this. That was one of my early ideas but would prefer to have them not go through at all but I guess there is no way of doing it. Appreciate your inputs brother. A always right on spot ---
**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:** [May 31, 2020, 4:44pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/6 "2020-05-31T16:44:40Z")
Yeah, Iā€™m not aware of a way to conditionally control the view details action. Maybe you could play around with the Enhanced Link to Screen option in staging by setting up a relation for each row that only fills based on the paid status from the user profile. If the relation is empty, then maybe it wonā€™t click through. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 31, 2020, 4:54pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/7 "2020-05-31T16:54:02Z")
Youā€™re spot on Jeff. I was just going to recommend this. After playing around with the link to screen on tile layout where link to screen was a relation, if the relation wasnā€™t there, clicking the tile did nothing. Otherwise, it went to the details screen. Neat use case. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 5:05pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/8 "2020-05-31T17:05:54Z")
Interesting notion. Love it. Unfortunately itā€™s only in staging for now. I will check this and see how to set this up. Very creative thinking Jeff šŸ‘šŸ‘ ---
**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:** [May 31, 2020, 5:07pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/9 "2020-05-31T17:07:49Z")
@Robert_Petitto Awsome! Good to know. @yinon_raviv nothing stays in staging long, especially once itā€™s been announced to test. I bet itā€™ll be released this week. Next week at the absolute latest. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 5:20pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/10 "2020-05-31T17:20:09Z")
In Hebrew we say inshallah which means in loose translation with gods will (or David and Mark šŸ˜„šŸ˜‰) ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 6:16pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/11 "2020-05-31T18:16:34Z")
Actually is Arabic and we embraced it šŸ˜… ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [May 31, 2020, 8:30pm UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/12 "2020-05-31T20:30:57Z")
@Jeff_Hager @Robert_Petitto So Iā€™ve created a column on my users sheet which indicates paid = yes and empty if not paid. Iā€™ve related it to a matching column on the guides sheet which indicates yes if this is a paid guide or empty if this is a free guide. Now, Iā€™m not sure how to set the enhenced link to screen. When Iā€™m choosing the relation as the data it open a list of the users which have yes on their paid column. Iā€™ve probably missed something in your idea but not sure what. ---
**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 1, 2020, 4:39am UTC](https://community.glideapps.com/t/brain-picking-members-area/10092/13 "2020-06-01T04:39:57Z")
You might have to use arrayformulas in the sheet for this. I think you would create 2 columns in the Guides sheet that indicates if itā€™s ā€˜Freeā€™ or ā€˜Paidā€™ and set them up as an array column. One column thatā€™s filled with ā€˜Freeā€™ joined with the Guide ID, but only for Free only guides. The second filled with ā€˜Paidā€™ and joined with the Guide ID, but for all rows. In the Users sheet, you will have a column that indicates if the user is ā€˜Freeā€™ or ā€˜Paidā€™. Assuming you are using user profiles, you should then be able to create a template of the userā€™s Free/Paid status joined with the Guide ID. Then create a relation using that template to join to the array column in the same sheet we created in earlier in the sheet. If the user status is ā€˜Freeā€™, then only the free guides should return a related row. If the user status is ā€˜Paidā€™ then all rows should return in the relation. You can then use the relation for the enhanced link to screen, which will be linking to the same row because Guide ID is part of the relation.