# Lifetime membership access, how to access App:Sales
**URL:** https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755
**Category:** Ask for Help
**Created:** [January 27, 2022, 7:05am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755 "2022-01-27T07:05:57Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 27, 2022, 7:05am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/1 "2022-01-27T07:05:57Z")
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 Glide tables, so I can’t create a relationship between the users sheet and the App:Sales sheet.
How do I connect the content on App:Sales to my user sheet? Is there another way to do that?
Thanks!
@Robert_Petitto @ThinhDinh @Jeff_Hager
👍
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 27, 2022, 8:36am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/2 "2022-01-27T08:36:58Z")
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.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 27, 2022, 11:34pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/3 "2022-01-27T23:34:38Z")
The formula you’re looking for is either:
```auto
={'App: Sales'!A:Z}
=QUERY('App: Sales'!A:Z,"SELECT * WHERE A IS NOT NULL",-1)
```
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 1:12am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/4 "2022-01-28T01:12:21Z")
> [@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?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 28, 2022, 1:20am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/5 "2022-01-28T01:20:56Z")
Usually I use the rowID of the product to know what they paid for, I usually have multiple products.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 28, 2022, 1:21am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/6 "2022-01-28T01:21:07Z")
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
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 2:48am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/7 "2022-01-28T02:48:02Z")
I literally just solved this today 🙂
> [@Buy button is invisible - why?](https://community.glideapps.com/t/buy-button-is-invisible-why/37676/22):
>
> 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 the User completes the sign in process I add a row to Glide Table called BUY. I set columns in this new row with all of the info needed to buy an item (description, price, image, etc…) plus some USER ID data (Row ID from the user sheet). When the user enters the shop screen I show an in-line list that reads the data in the BUY table and pr…
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 7:16am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/8 "2022-01-28T07:16:42Z")
Sounds like you cracked it! I’m still just cracking my head. Any chance I can make a copy of your app? 👍 👍 👍 🤩
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 11:35am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/9 "2022-01-28T11:35:44Z")
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?
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 11:52am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/10 "2022-01-28T11:52:09Z")
That would be super amazing 🙏🙏🙏🦋🙏
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 3:20pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/11 "2022-01-28T15:20:38Z")
Here is a little video to demo the App called GoodBuy.
https://player.vimeo.com/video/671179178?h=4c80a91684&app_id=122963
This is the code for the Google Sheet clone: you can have a new Google sheet and use the formula below in cell A1.
```auto
={'App: Sales'!A:Z}
```
This will duplicate your App: Sales sheet and allow you to see it in the editor.
The app can be copied. Hope it’s all clear!
Enjoy.
> **[GOODBUY](https://good-buy.glideapp.io/)**
>
> Demo app: How to track items bought with Glide's BUY button using STRIPE
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 8:54pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/13 "2022-01-28T20:54:01Z")
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 😍
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 8:56pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/14 "2022-01-28T20:56:35Z")
> [@Simon\_Hill](#):
>
> [https://good-buy.glideapp.io/](https://good-buy.glideapp.io/)
Hi @Simon_Hill I was not able to duplicate the app, it’s telling me there are too many rows, see attached. Perhaps
you can delete the rows you don’t use?
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 9:07pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/15 "2022-01-28T21:07:03Z")
Oh really? I don’t know why that would happen. It is a really small App with hardly any rows… I will take a look at the Google Spreadsheet and check to see if there are any redundant sheets. I don’t think so!
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 9:11pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/16 "2022-01-28T21:11:44Z")
It may count all the rows if you have just one cell with content, let’s say 1000 rows down.
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 9:14pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/17 "2022-01-28T21:14:28Z")
Ok… checking. I did work on a 2nd hand sheet.
I just switched off a ‘Calculations mode’ related to refreshing circular arguments from the old sheet. Can you try now?
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 9:16pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/18 "2022-01-28T21:16:09Z")
I’m getting the same error @Simon_Hill 🤔
"An error occurred duplicating the app.
In most cases this is caused by a large and/or complex Google sheet. Delete all rows and columns that your app is not using or there is no data. Glide will append rows as needed so you can remove all empty rows below the existing data on all of your sheets. Then try to duplicate the app again."
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 9:18pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/19 "2022-01-28T21:18:56Z")
If you can share your email address I can share the Google sheet with you and maybe you can check. I don’t have experience in this error!
---
### Author:  [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 28, 2022, 9:19pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/20 "2022-01-28T21:19:13Z")
Sending you DM
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 28, 2022, 9:35pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/21 "2022-01-28T21:35:03Z")
You might check your arrayformulas, probably you writing empty values all the way down the sheet
[Next page](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755.md?page=2)