Hello guys, I want to allow only paying members to access certain areas of the app. This is a one time payment that gives them a lifetime access. I added a couple of products and integrated with Stripe. The problem is that all the purchases are showing in a sheet on Google Sheet that I can’t see on…

The formula you’re looking for is either: ={'App: Sales'!A:Z} =QUERY('App: Sales'!A:Z,"SELECT * WHERE A IS NOT NULL",-1)

Just make a read only copy of your App:Sales sheet, using either an arrayformula or a query. Glide will see this sheet, and you can build relations to it.

[image] ThinhDinh: ={'App: Sales'!A:Z} Thank you so much @ThinhDinh ! what is your strategy for creating a relationship with this sheet to determine who paid for what product?

Usually I use the rowID of the product to know what they paid for, I usually have multiple products.

have a product category and relate them to users who paid… product_name#category#date, make a description in pay link, so you can easily filter it or relate after split

I literally just solved this today :slight_smile: [image] Buy button is invisible - why? Ask for Help Ok I think I cracked it. How to get instant notification when a user buys something using Stripe (caveat: you need to have an App with a Google sheet). When…

Sounds like you cracked it! I’m still just cracking my head. Any chance I can make a copy of your app? :+1: :+1: :+1: :star_struck:

Would it be OK if I create a super basic new app with the same buy feature? I will make the new App available to copy?

That would be super amazing :pray::pray::pray::butterfly::pray:

Here is a little video to demo the App called GoodBuy. This is the code for the Google Sheet clone: you can have a new Google sheet and use the formula below in cell A1. ={'App: Sales'!A:Z} This will duplicate your App: Sales sheet and allow you to see it in the editor. The app can …

Wow this is very generous! Thank you so much. And by the way, what a clever name haha! I’m going to start watching and report back. Thanks again @Simon_Hill :heart_eyes:

Lifetime membership access, how to access App:Sales

Ask for Help

Simon_Hill January 28, 2022, 2:48am 7

I literally just solved this today

Topic		Replies	Views
Connect Stripe "App: Sales" data to Users Ask for Help	2	781	May 12, 2021
Stripe payment => add a value into user account Ask for Help	2	372	June 1, 2021
How to use stripe sheet to the glide app Ask for Help	11	502	October 10, 2021
"App: Sales" in a Glide Sheet app Feature Requests	9	660	January 29, 2022
Shopping cart data Ask for Help	23	722	August 14, 2021

Lifetime membership access, how to access App:Sales

Related topics