"Sticky data" - showing the same info while browsing profiles

Ask for Help
1

Hi!

My app contains profiles of users. Each user has “friends” who are other users in the app. When you open a user profile, you can see the friends of that user.

I want the app to show users their own friends, just below the other user’s friends. So that no matter which profile I open, I also see my friends list within it.

Any idea? :sweat_smile:

2

Hey,

You should be able to do that with a couple of inline lists in a ‘details’ layout.

  • First list an inline list of friends with a relation to profile selected
  • Second one the same but in a relation to signed in user

Good luck!

1 Like
3

How do you tag the friends of your users? If you use a sheet Ith 2 columns, first is User ID and the other is Friend ID, you can populate this sheet using a form each time a user add a new friend. And after, use an inline list to display the user’s friends (filter of the inline list = the target user ID)

2 Likes
4

Can you describe your data structure? How do you associate user-to-user “friends”?

1 Like
5

Hey George!
Thanks for answering.
How do I create the list related to the signed in user?

I’m not sure my data structure allows that. Every profile is a row, and every row contains six columns, each for one friend.

Thanks

6

Hi Cristohe,

Thanks for your help!

I structured the data differently. Every profile is a row, and every row contains six columns, each for one friend.

I did it this way to save on DB space, as I understood there is a limitation on the number of rows Glide can support.

Thanks

1 Like
7

Hi,
Sure.
Every profile is a row, and every row contains six columns, each for one friend. I did it this way to avoid reaching quickly the 25k rows limitation…

Thanks

8

It’s not really a limitation for pro app, but let’s say a “warning” because with more than 25k rows, your app could be impacted by Google sheet performance issues. It depends on your sheet, if it contents some formulas, à lot of formulas or a huuuge number of formula. If your amount of formula is moderated, you could go up to 50k or even 100k rows. But you’re advised it can be less.

Cheers and enjoy Glide-ing!

1 Like
9

Thanks a lot!

1 Like
10

You can always store data on a separate sheet and use a combination of VLOOKUP and IMPORTRANGE to call that data to you app. I do this a lot actually. You set a script to nightly move the current day’s data to the sheet and the parts of the app that requires this information is able to pull the data as needed.

1 Like
11

Hey I would do it @Christophe_HK’s way and change the structure of your data :slight_smile:

1 Like
12

I also think @Christophe_HK’s way would be better, so you are limited by the number of friends you can have, but it you want to stick with the 6 column idea, then @George_Lewis1 has a good point with 2 inline lists. The profile list will be easy since you should have an array column created from the 6 columns. You can use to array column to create a relation back to the same profile sheet and use it for the first inline list. For the second list of the signed in user’s friends, create a template column that gets the signed in user’s email from the user profile. Create a single relation that uses the template email column to link back to the profile sheet. Create a lookup column that gets the friends array for the singed in user. Finally create a relation column that uses the lookup friend array column to link to the profile sheet. Use this final relation for the second inline list. It will display the signed in user’s friends on the same page as any other profile they are viewing.

2 Likes
13

Thanks a lot for the detailed explanation!
I’ll go @Christophe_HK way :slight_smile:

1 Like
14

Hi Jeff,

I’m trying to implement your suggestion, but I can’t really follow the logic, and for some reason I can’t make it work.

What do you mean by “create a template column that gets the signed in user’s email from the user profile.” - Should I add this column in the Profiles sheet? Anyway, I did this and followed the next steps, but when trying to perform the last step, I couldn’t create a relation based on the “lookup friends array column”.

I feel like I’m missing here something.

(Just to clarify before I proceed - currently all the profiles data, and the related friends, are managed in the same “Profiles” sheet).

Happy if you could help again, and thanks a lot!

15

Are you using user profiles as outline here?

https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles

Yes, you would create the template column on your user profiles sheet.

1 Like
16

Followed instructions in the link you sent and now it’s working.
Amazing!
Thanks

2 Likes