Sync data from another Glide table based on a criteria

Ask for Help
1

Hello to all,

Can anyone please tell me if there is a possibility to sync data from another Glide table, with an excel formula or another functionality like in the example below:

I have the table users and let’s say I have a boolean field for visibility - all the users that have this field checked will be visible to others, everyone else shouldn’t.
As in the users table I have row owners, just to display the data from that table it’s not possible, and if I remove the row owners and use the users table, the app will download the entire data and only hide the ones that are not available … so it’s not the best solution.

What I wan to achieve, is to have another table that can be populated only with the users that have that field checked and in this way I can display only the ones that have truly marked the field.

So, any suggestions ?

Thanks a lot in advance.

2

You can’t use row owners on a non-email column, I believe. From the Glide Docs:

Row Owners lets you restrict who can download data based on the email address they sign in with. If a sheet has Row Owners enabled, then the current user can only download rows that they own.

Do you only use Glide Tables or do you store your user profiles table in Google Sheets. I think we have two ways to go forward here:

  • If it’s in Sheets, use a filter formula to generate a public second sheet with only “public” profiles
  • Use a Roles setup.
3

Hi @ThinhDinh

Thanks for your reply.

I’ve created a video for what I want to achieve. You can see it here:

4

@Sean_Martin , can you also ask the team maybe they can give me a hint … Much appreciated. Thanks.

5

Yeah I think you made your requirements clear from the original post.

Just to be clear, is data privacy the most important criteria here for the task? If you don’t mind people downloading rows that they should not see, then a simple filter would work. Otherwise you have to settle for a Roles setup.

1 Like
6

Roles is very limited to a certain amount of private users, so I don’t see the option to be able to implement it using roles … I’m thinking of using google spreadsheets to achieve or airtable , but can you tell me if when connecting a spreadsheet with Glide, the spreadsheet will be made public or it’s on a private connection with Glide only ?

7

If you authenticated glide using your Google account, then it has access to your spreadsheet. The spreadsheet does not need to be publicly accessible. Glide has a direct private connection to the spreadsheet.

2 Likes