Please vote for User Specific Rollups Feature Request here:
Yesterday we got from 6 to 15 votes and I am sure there are more than 15 people that want the user specific columns to roll up! So let’s go! 
5 Likes
Hey everyone!
I’m new to glide, but have spent hours learning through the glide’s tutorials, and other user’s tutorials (thanks to everyone)
My question is this:
I’m building an app that have users and user-generated content (mainly they will upload pictures) and I would that when someone views this user-generated content, to give the author credit by displaying the user’s profile of the person that uploaded that content.
Initially I created an relation to link the user’s email that uploaded the content, with the user’s sign-in email. Then I created an inline list inside the actual content to display the authors name… BUT this is only showing if the user that uploaded the content is signed in (it’s not available for other users to see it).
I’m guessing this is because I have the user’s email as the Row Owner…
Can someone help me solve this? Thanks in advance!
You probably need a “profile sheet that holds a row for each user containing information that they can share throughout the app. Do not use this for login authentication (use your existing sheet). The sheet used for authentication does not need to be the same sheet used to hold a profile.
Have you tried the following:
- Set up user profiles in your app.
- Where you want user to upload their content, use a form component.
- In the form component, include a user-profile column with email.
- Create a relation between your use-generated content and your user-profile sheets using email.
- No need to use the row owners column feature in the GDE.
2 Likes
Just make sure that you’re happy and fully understand what it means to remove the Row Owner if that is your chosen route.
2 Likes
Thanks! I did this and it worked!
Since I’m not asking for any sensitive information from my users (just their social profiles IF they want to add them), I opted to remove the “Row Owner” and this way it worked perfectly.
Thanks everyone for your help!
1 Like
Sorry if this has been asked before, but can an existing “Whitelist Email” tab be used instead of creating a whole new “Users” tab? I already have a ton of manual conditions in place and I’d like to simply add a new column to my existing whitelist tab and use that for visibility settings whenever I make a new tab within my app. I don’t really have users signing up for the first time since my app is older. Not sure why I’d want two tabs in my Google sheet full of user data if I’m already collecting emails and assigning access to features in my whitelist tab.
Yes, you can set the user profiles to use any sheet you would like.
Oh, that’s great to know. Maybe I’m not understanding how to set up user profiles. I do not have a “Sign In” option as suggested at 2:20 in the tutorial. And every attempt to activate prompts a grayed-out visibility option.
Have you enabled User Profiles? Seems like a no?
If you don’t have a sign in method enabled, how is your app supposed to know who the user is? Since you mentioned a whitelist sheet, I assumed you have a private plan, which requires sign in and allows for a whitelisted list of emails that restricts app access to only those user emails. However, User Profiles work with ‘Public with Email’ as well as ‘Private with Email’, but one of those methods needs to be enabled before you can proceed with enabling User Profiles. Once User Profiles are enabled, then you can then set visibility on tabs.
https://docs.glideapps.com/all/reference/security-and-per-user-data/user-profiles
1 Like
Thanks for the help. Re-watched the video and figured out you have to be inside a profile to activate. That was my issue. Thanks again!
1 Like
hello there, my app is ‘public with email’ ,so when someone enters email and sign in where is their email stored?
The email is stored internally within glide for authentication and row owner purposes. If you have user profiles enabled, it’s also stored in your user profile table. It’s also stored in any table that you write the email to. Also, the authentication is cached locally so it signs you in automatically when you open the app again.
6 Likes
Hi @Jeff_Hager, one thing I don’t understand. I saw that the application is linked to the Google sheet and I noticed that there are two “exclusive” tabs: Logins and comments.
Checking within Glide though, these two archives are not visible.
As I wrote in another post, I’m interested in seeing and showing inside the profile, the date of registration. How can I recover it? Thanks as always
Those “exlusive” tabs are just logs for whatever you want to use them for. They’re not meant to be shown within glide. But, you have a couple of options in the google sheet if you do want to see the data in the app.
- One is that you could use a VLOOKUP formula to pull the date, for example, into the the user profile table.
- The other option is to duplicate the App: Logins table by creating a new table and putting the following formula in the A1 cell. That way it will be a current duplicate of the App:Logins table and it will be accessible within your app. But keep in mind that this method will use more rows as they will now be part of your app.
={App: Logins!A1:D}
4 Likes
Right! Thank you, my solver 
1 Like
Hi @Jeff_Hager, I solved it this way and it works fine:
I imported the email column from App: Logins, so it would be visible in Glide;
I created a relationship between user emails and the emails in this new repository that I called UserLog;
I made a LookUp of the date of this archive;
with the Rollup function, I have searched in the date the first one recorded.
With this system I can visualize the first access date of each user that corresponds to the registration date and so, if the user deletes himself but then thinks again and registers with the same email, I can visualize the date of his first registration.
This is to share my approach with everyone. If you have a simpler one, I’d love to know about it.
3 Likes
I’m not able to use user profiles and user specific columns even though I have the privacy setup as:
Access: Private
Users: Users in the users table
Should i ask the user consent for authentication cookie?
What do you mean by “not able to use user profiles and user specific columns”? Can you share some screenshots?
User-specific columns should be available regardless of your privacy setup, user profiles is only not available when you don’t allow anyone to log in.