Public data on a private profile (row owner& array)

Hello,

I have an employee directory in app. Employer admin should be able to consult limited public data about each employee.

I don’t want a workaround like to manage 2 independent tables (private user;public user) like i tried before (“make your profile public” button and it was recopied in another table, but never updated then…)

I found the solution, but its for google sheet, i cant manage to reproduce with Glide table ! (I want only Glide tables in my app, it’s faster and Glide team keep encouraging using it, so…)

EXAMPLE 2 is my goal.

Thanks for your help again

To get example 2 from the docs using only Glide tables, probably the easiest way would be to use an onboarding process for each new user. At the end of the onboarding process, have them tap a button and use an action with that button to set a secondary owner column in their User Profile row to an appropriate value. This could be the email address of your Admin user, or it could be a Role that is assigned to multiple Admins.

1 Like

Oh im so confuse !

My mistake, i wish to create the same result as end of EXAMPLE 1, : “Instead, we can mirror the non-private columns from the User Profiles sheet and display them in a second sheet. Then we can show the data in the non-private sheet without Row Owners. …”

(Your workaround to example 2 is still interesting for something else… thks anyway :wink: )

Okay, example 1 is more difficult.

There is no way to do it with computed columns, because with Row Owners on the main Users table, most rows won’t even exist on user devices. So computed columns will have no effect.

This is just off the top of my head, so it might not be the best approach. But here is one way that could work:

You would need to modify every action that updates your User Profiles table, so that it updates the corresponding row in your Public Users table at the same time. That’s probably not as bad as it sounds. All you would need is a single relation from your User Profiles table to your Public Users table, and you can do a Set Column values via that relation every time you have an action that modifies a User Profile column. You’d probably still need an onboarding step to create the Public User row for each new user.

1 Like

Thank you for your answer,

Please find my precise goal below (screenshot from glide app documentation)

You confirm its not possible in a glide table ? only google sheets ?
No equivalent function provided by Glide ?

No, that’s not possible unless you use something external to Glide such as Make. But it would require a Business or Enterprise subscription so that you have access to the Get All Rows API call.

With that, you could periodically fetch all rows from your User Profiles table via the API, and then write them back through the API into a Public Users table.

2 Likes

@Robert_Petitto

Hello,

Maybe you could help us on this topic ?

i dont get why the Glide doc says we can…

Have a nice day,

The example from the docs that you want is referring to mirroring your users table in a Google Spreadsheet using an arrayformula.

But you stated that you want to use Glide Tables only, so that option is not available. As to why there is no equivalent function in Glide Tables, I already gave you the answer to that:

1 Like

Here’s what I do. I still create two different tables (even though I wish we didn’t have to).

  1. a users table with sensitive information protected by row owners
  2. a public profile table without sensitive info.

What I typically do is have an onboarding screen that ultimately generates a new row in the “profiles” table with the public info. I record the Row ID of the user in this table.

I then create a relation from the user table to the profile table. In my app, I allow my users to edit their “user” table info and “on submit”, update the public profile info through the relation.

I should probably create a video.

3 Likes

hehe, exactly what I suggested :joy:

2 Likes

Thank you guys ! :pray:

You are amazing:)

@Darren_Murphy thank you !
I used to do this technic before you told me how to… but i was going crazy with everything double ^^ user had to tap something like “make my profile public” before being able to chat between each other.
And …. when they had to edit the public profile separately - i was not using the row id relation…

Glide team should add an hint on the doc:
« Only possible on google sheets for now. »
Especially as the future seems to be glide table only…

It’s such a common function… at least any good/secure directory needs it.

Have a nice day :slight_smile: