# Private Sign in, Limit Access by Email **URL:** \ **Category:** Ask for Help\ **Created:** [December 17, 2020, 2:54pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992 "2020-12-17T14:54:07Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 17, 2020, 2:54pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/1 "2020-12-17T14:54:07Z")
Hi! Is this the same as Private Pro or under the Regular Pro category? Also, the sheet that you select in the sign in settings, how does it know which column to pull from for the allowed email addresses? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 17, 2020, 2:57pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/2 "2020-12-17T14:57:05Z")
> [@Jen\_NYCP](#): > > Is this the same as Private Pro or under the Regular Pro category? Limit by email address is only available with [Private (paid per user) apps](https://www.glideapps.com/pricing). > [@Jen\_NYCP](#): > > Also, the sheet that you select in the sign in settings, how does it know which column to pull from for the allowed email addresses? This is configured in the Privacy settings: ![Screen Shot 2020-12-17 at 10.55.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/1640a2e7444ae40d0d30fecb7f23cfc9647af80f.png) ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 17, 2020, 3:02pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/3 "2020-12-17T15:02:05Z")
Oh so you have to have a sheet with just the emails? How can I select it under regular pro then? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 17, 2020, 3:05pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/4 "2020-12-17T15:05:16Z")
As I learned from @Jeff_Hager, it doesn’t have to be a dedicated sheet. ie. It can be the same sheet that you use for User Profiles. You can’t select it for regular pro plans, as it isn’t available for those plans (unless, as I understand it, you have a legacy pro plan that was extended when the new pricing came in a few months ago) ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 17, 2020, 3:07pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/5 "2020-12-17T15:07:41Z")
Ah I see, so if I select my user profile sheet, how does it know which column to pull the allowed email address from? Oh yes I have a Pro Legacy Plan, so I guess it won’t be an option when I have to renew. I just need more then 20 private with email slots and I see there is a limit for Private Pro. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 17, 2020, 3:10pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/6 "2020-12-17T15:10:22Z")
> [@Jen\_NYCP](#): > > Ah I see, so if I select my user profile sheet, how does it know which row to pull the allowed email address from? I guess the assumption is that you only have one email column in that sheet, and it uses that. I haven’t tried pointing it at a sheet that has multiple email address columns, so I don’t know what would happen - I suspect it may refuse to use it… ---
**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:** [December 17, 2020, 3:48pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/7 "2020-12-17T15:48:24Z")
Good point, I have an app but have not tested if having multiple email columns would break it. Actually I have never had a sheet that has multiple email columns though, when I do it’s grouped into an array column anyway. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 17, 2020, 5:58pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/8 "2020-12-17T17:58:05Z")
Only one column has email addresses, so when you select the sheet it just knows which column to use? Also for private with email, only 20 emails address can be used? ---
**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:** [December 17, 2020, 6:25pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/9 "2020-12-17T18:25:20Z")
It’s Magic! 😉 I’m not sure either how it knows where to find the emails in the sheet, but it just works. 20 users is not a limit. It’s just the minimum number of unique users allowed for the base plan price. Any more than 20 users and you are billed per additional user of the app. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 17, 2020, 6:49pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/10 "2020-12-17T18:49:12Z")
Ha ok got it! So I set up visibility once signed in for a button, but it’s only pulling the email address from the first business, I would like for it to apply to all email addresses in that column. Am I missing a setting? ![button1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aecbedc4636e11322e8a37ec396fbf930c5c1a23.png) ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 17, 2020, 11:59pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/11 "2020-12-17T23:59:20Z")
Bump. 🚘 ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 18, 2020, 3:33am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/12 "2020-12-18T03:33:14Z")
Anyone know what I am doing wrong? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 3:45am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/13 "2020-12-18T03:45:07Z")
Does the By Neighborhood sheet have row owners enabled? If yes, that would explain it. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 18, 2020, 7:10am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/14 "2020-12-18T07:10:49Z")
No I do not have that ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 7:18am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/15 "2020-12-18T07:18:19Z")
Okay, so the button has a link to screen action, which points at the By Neighborhood sheet. And then when you click the button, you get sent to that screen and only one record is displayed, yes? Which components do you have on that screen, and how are they configured? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 18, 2020, 7:23am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/16 "2020-12-18T07:23:59Z")
First I have a sign-in button, and when a business signs in, where their email matches one in my email column, another button is seen. That is where that setting is setup. So pretty much the button is only showing up when I am signed in as the first business and not the others. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 7:33am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/17 "2020-12-18T07:33:01Z")
oh, right… Okay, I was completely barking up the wrong tree 😂 Okay, so presumably you have a relation between the two sheets using email address? You can use the state of that relation to set the button visibility. If it’s empty, don’t show the button. And vice versa. Does that help? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 18, 2020, 7:35am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/18 "2020-12-18T07:35:04Z")
Hmm, there is only one sheet. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 7:37am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/19 "2020-12-18T07:37:34Z")
So your Business Owners sheet is also your User Profiles sheet? (nothing wrong if it is, I’m just trying to visualise your setup) ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 18, 2020, 7:44am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/20 "2020-12-18T07:44:13Z")
Yes, same sheet.Thanks! [Next page](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992.md?page=2)