I am new to glide. I am trying to test adding new users, but I discovered that everytime I delete a user manually from the database, and I try to sign in again with that same email, it does not add that email back to the user’s table, even though it will successfully sign in that email into the application. Please has anyone experience or observed this? and how can this be fixed?
Update: I am using glide’s internal database table.
You need to delete the user data on Glide’s end. They still track a user separately from your user table.
Hi, you will notice each of your users has an email address – in a free app or one where you are not collecting real email addresses, it will have an anonymous email.
On your data tab, you will need to type in the user email to delete all data (this will delete all references to that user, including logins and user-specific-data that Glide has stored for that user.
You can do this even after you’ve deleted the user as long as you know (or can remember) the email address.
Thank you @Jeff_Hager and @David_Gabler When I try to delete the email using the method that @David_Gabler suggested, I got an error saying “That user still has a row in the user profile table. Please delete that row first, then try again.” But I cannot see the row.
Double check which table Glide thinks is your user table. On the left side of the builder, click on “user profile”
And then on the right side, look and see which table is specified as the sheet:
@Jeff_Hager @David_Gabler
so first here is my users table
And from the image below, it shows that the user profile is pointing to my users table
Another thing I will like to mention how I initially delete this users, I mark the checkbox at the beginning of the user row, and click on the delete button on my keyboard, and that row disappears.
Also when I click on the view as user in the image below, initially this emails do not show up, but when I completely type in the email in the searchbox, it will show the email as part of the users list. but I do not think this one has anything to do with the users table, or does it?
That’s interesting. The only other thought that I have is if you’ve implemented row owners in any of the sub-tables; perhaps that user entered a row. You would probably need to delete any rows manually they entered under that scenario. I know Glide takes care of deleting the user-specific columns, but I don’t think they delete owned rows.
Okay, thanks. I will check that, and keep investigating. If I ever get a solution, I will be sure to update it here.
I’m not completely sure if it matters if you use the anonymous email address or the real email address when deleting user data. I would at least try both versions of the email address if you happen to know them.
Yes, I always use BOTH! I wish Glide would let us know which one to use.
I think I select the option to “collect real user email address” under the privacy settings. But the good thing now is that I know the correct way to delete a user from the editor. I created a workflow to delete the currently viewed user, which deletes the user. And when I signed in again, it recreated the user to the database.
I think my next problem is how to create a column in the user table, that will have a default value of standard user. I really appreciate your time guys, any clue will be really helpful.
What I would do is first create a normal user type column. It will be empty when a new user row is generated, which is ok. I don’t think there really is a way to populate it automatically. Next, you have a couple of options:
The only potential problem with the above methods, is that if you plan to use your user type column as a role column for row owners, then the user will be unable to set their own user type for security purposes. Only another user with the same role/user type can set a new user’s role/usertype. Also, you will unable to use an IF column for roles or row owners. You can, however, still use the above methods for filtering and controlling who can add or edit data. I could probably go on and on with what you can and can’t do, but it really depends on your specific scenario. Hopefully this gives you some ideas to consider.
Thank you very much for your reply @Jeff_Hager I have tried creating a column type ‘If->Then->else’, my only problem is that when I create a new column, say ‘Role’ column, I cannot use that same column in the IF expression. I can only use other columns in the IF expression. And from your explanation, it seems like you’re saying that I can use that same column I am creating in the IF expression, is that right?
If not, please how can I do what you said here?: “Another option is to create an IF column. If the user type is empty, then return ‘Standard’, else return the value that’s in the user type column.” I understand this to mean, create a column with say, label ‘Role’, check if the ‘Role’ is empty, if it is, return ‘Standard’, else return the value that is in the ‘Role’ column. If I did not get you well, can you explain the sentence a bit clearer.
He meant something like a “Role Fixed” column, where you cover the empty actual “Role” column values by assigning it a value. You can’t use the same column you are creating in an If Then Else column.
I am experiencing a similar issue, see Glide Data table not transferred across App and Pages
Okay, thanks @ThinhDinh I understand.
