Find all the products of a certain user and combine them into user list

[SuperMerabh]

Hello!

I am working on a membership app. I need to show some items only to people who bought a certain membership, I have 2 types of memberships (“training” and “membership”). Everything is working except I need a way to look for all the membership types a user bought and combine them into one cell ON user table. I tried to do it with Glide tables, it worked but then I couldn’t use the info on the visibility condition. So now I want to do it with Google Sheets.

I have App: Sales table with all the info

And then I have a users table with a column “Access” where I want to find all the products the user bought and combine then like this

Any help is appreciated!
@ThinhDinh @Robert_Petitto

Thank you!

[Uzo]

In the Glide table, You can use the relation column, to relate the user’s table email addresses to sales email addresses (mark multiple), then lookup that relation for membership, it will bring joined cell of all the memberships purchased by a member.

In google sheets… use the sort and vlookup functions

I assume that you are most interested in the current status of membership… not to join purchases.

[ThinhDinh]

@SuperMerabh

Everything is working except I need a way to look for all the membership types a user bought and combine them into one cell ON user table. I tried to do it with Glide tables, it worked but then I couldn’t use the info on the visibility condition.

I wondered what “did not work” here? It looks like you have the right setup and the only problem should be the visibility conditions. Can you share the problem?

If you have the same setup with your own “Sales” table then with Glide Tables:

• Create a relation using the email of the user as the connector, from your Users sheet to the Sales sheet.

• Use a joined list column on top of the relation above to return all “Item SKUs” to know which types of membership a user has bought.

It should be the same with Sheets, except you have to “duplicate” the App: Sales table by a formula to make it visible to Glide, if you want to do the relation way.

If you want it to be a Sheet column with an arrayformula then I guess it’s more tricky. If you want it let me know.

[SuperMerabh]

@Uzo

In the Glide table, You can use the relation column, to relate the user’s table email addresses to sales email addresses (mark multiple), then lookup that relation for membership, it will bring joined cell of all the memberships purchased by a member.

Thank you! The issue was that I was not able to use the info on joined column in the visibility condition, it was just letting me choose empty/not empty

[Uzo]

this is weird maybe a bug… I was able to join multiple lookups in my app, but now… I tried to recreate that to make a sample for you… and I can’t do it anymore.
so maybe you use technic as I show you for the spreadsheet… to just find the latest payment

but is working in the app… LOL

so try to join your lookup and then even if in editor is showing empty, in the app should work to filter it

[SuperMerabh]

@ThinhDinh

If you want it to be a Sheet column with an arrayformula then I guess it’s more tricky. If you want it let me know.

I found a way to do it with just two products, looking for first and last purchase, but it will only work with 2 products…I’ll post more details when I have it. Thank you @ThinhDinh !