I am currently on the ProApp plan.
First, I set the publish to private.
After that, I set Users in the users table to the user table and tried to log in, but it says that this email address is not allowed to access, so the PIN code is not sent.
I created a table of email addresses with Any email in table and tried to log in, but I can’t log in with the same error.
Please let me know how can I allow only certain users to login.
There are a few different ways to achieve this, but let’s use the most common example, which is users that you already added to your User Profiles table. The Privacy settings you need for this are:
If you can’t get it working, please provide screen shots of:
When I set “Access” to “Private”, “Users in the Users table” does not appear in the SignIn options.
On the other hand, if you set “Access” to “Public”, “Users in the Users table” will appear in the SignIn options.
However, this setup does not solve my problem.
Your first two screen shots appear to be from two different Apps.
They both show Privacy settings, but the first is the new configuration and the second is the old.
So which is the one from the App you are having problems with?
I made a slight mistake with my earlier advice:
that should actually be:
Once you select Access → Private, sign in is automatically required, and so the sign in settings are hidden. Apologies for the misinformation.
Anyway, you’ve given two different versions of the Privacy settings, so we need to first establish which is the one you’re actually dealing with.
The first screenshot is to illustrate the current access settings.
Login fails with the second screenshot setting.
What you told me is similar to the second screenshot setting.
When I try to log in with the second screenshot setting, it says I can’t log in because I don’t have access.
ah, okay… I assume that you have added your email address to the Users table?
Can you show me what that looks like? (hide any private info if you need to)
The user table is set correctly.
I have prepared a screenshot.
Could this be possible only with the Private Pro plan?
Okay, as far as I can see everything that you’ve shown me looks correct.
Can you try something please?
Try changing your privacy settings to Public/Optional/Anyone, and see if you can sign in using an email address that already exists in your Users table.
I realise these aren’t the settings you want, I’d just like to know if it works.
If it does work, please check your Users table to see if a new row is created, or whether your login is linked to an existing row.
I tried the method you suggested, but I couldn’t log in.
I have the user table specified correctly, but it seems to me that the user table is not working.
Is this a bug?
I’d be very surprised if it’s a bug, as if it was it would be affecting Glide users all over the world.
It must be something specific to your App, but at the moment I can’t see what it is.
For example,
With this setting, I can log in.
If so, the PIN was sent and successfully added to my spreadsheet.
But the Users settings,
・Users in the users table
・My team
・Any email in table
Login does not work properly with these settings.
It says you don’t have access rights.
The user table is set up correctly as you can see in the screenshot above.
I also checked if there was a problem with the text data in the spreadsheet, but I didn’t see any problems.
Should I use the Limit Access Email feature of the Private Pro App plan?
If it is impossible, we have no choice but to implement a pseudo-login function using the VISIBILITY function.
Wait…
You told me this didn’t work…
So now… tell me… did you look at your Glide Users table after you were able to log in, like I asked?
??
Sorry, my explanation was bad.
What didn’t work was
Access → Public
Sign In → Optional
Users → Users in the users table
I just wanted to let you know about this setting.
A new row was created in the user table.
A login is linked to an existing row.
But change it to Private,
・Users in the users table
・My team
・Any email in table
If you set these three, you won’t have access.
Why. . . .
um, it can’t be both of the above. Either a new row was created, or the login was attached to an existing row. Anyway, I’ll assume that a new row was created. If that’s the case, that would suggest to me that the email address that you used to login didn’t already exist in your Users table. Which may explain why you couldn’t log in when sign in is restricted.
The next test I would ask you to do is to leave that new row in the users table (ie. don’t delete it), then change your privacy settings back to Private/Users in users table, and then try signing in again with that same email address that you used for the previous test.
I would expect that to work.
Looks like my explanation was bad again.
In the previous test, no new rows were added.
That is, I found the fact that the user’s data is being referenced.
So I tried the following tests you suggested.
"The next test I would ask you to do is to leave that new row in the users table (ie. don’t delete it), then change your privacy settings back to Private/Users in users table, and then try signing in again with that same email address that you used for the previous test.
”
However, I still couldn’t log in. . .
Okay, we seem to be going around in circles here. If you would be prepared to give me temporary access to your Team & App I may be able to figure out the problem.
Otherwise, it may be best to log a Support Ticket with Glide.
Sorry, we cannot open access to third parties as it contains user data.
Thanks for your support.
