User profiles as admin and homepage for row owners

I am trying to create users page visible to admin and row owners page visible to all row owners. Is it possible without creating an alternate tab withImportrange? If yes, please share.

Thanks for your help!

So you want an admin to view all users, but the users can only see their own row?

Exactly. I have made the users tab visible to admin only. But row ownership restricts it to my profile. If I remove it, onboarding becomes an issue as I see my email in user’s profile setup screen.

Do you plan to have multiple admins or just one?

1 Like

One is required. More is better.

The general solution should be having an inline list that filters email is signed-in user or type is admin.

Another way is to have an email 1 column to store the user email, and email 2 column to store the admin email. Then set row owner on the generated array column. But it would work only when you have 1 admin.

1 Like

Tried the first approach doesn’t work with on boarding.

Regarding second approach, may work but not the best solution. Let me try that. If something else comes to your mind please let me know.

Can you explain more about why it doesn’t work?

1 Like

It shows my email when user logs in for the first time instead of the e-mail he signed in with as it is reading the first row. I restricted the visibility to e-mail-> signed in user.

I assume you’re pointing the tab to Profiles sheet right? Go to the Features of that tab, filter email is signed-in user so users can only see their info.

Let it be the “Your Profile” tab, where users can see their own information and edit it.

Make another tab named “Users”, set tab visibility to type is Admin, no filter is needed there.

Remove the row owner in your settings for the Profiles, then it should work for both types.

That’s what I tried but is not working. May be I am making a mistake somewhere. Will try again tomorrow.

Send me some screenshots if you need help!

1 Like

Thanks let me try again. If it doesn’t work. Will send you pics. Thanks @ThinhDinh

1 Like

You were right. I created 4 on boarding screens. Visiblity was issue in 1st not the other three so glide was not overwriting data. Should work now.

1 Like

Nice to hear!

1 Like