# 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:** 2

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 28, 2022, 9:40pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/22 "2022-01-28T21:40:14Z")

</div>

Well we use the formula in cell A1 to clone the Sales Log sheet. But this should not really cause an issue…

I have reported the issue. Maybe Glide Support can take a look.

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 28, 2022, 9:41pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/23 "2022-01-28T21:41:12Z")

</div>

Can you paste that formula ?

---

<div class="post-metadata">

### Author: ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)
#### Post date: [January 29, 2022, 12:09am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/24 "2022-01-29T00:09:14Z")

</div>

> [@Simon\_Hill](#):
>
> `={'App: Sales'!A:Z}`

This one

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 6:20am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/25 "2022-01-29T06:20:09Z")

</div>

Morning. I just went into the App and there was an Error. No idea why but the Glide Tab that showed the history of sales had become detached from any data source. It’s never happened before to me before… it gave an error message ‘screen lost’. I reconnected the tab to the Google sheet and instantly the App behaved fine again.

I then tried to copy the App for myself… and it worked fine. I now have 2 versions in my Glide home page:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88357413ec74c89e53d825fa3250a997b40355da.png)

The fix above might be a coincidence since it doesn’t seem like a dramatic change but certainly its possible to make a copy this morning. Could you have another go please?

> **[GOODBUY](https://good-buy.glideapp.io/)**
>
> Demo app: How to track items bought with Glide's BUY button using STRIPE

Regards,  
Simon.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2022, 6:33am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/26 "2022-01-29T06:33:24Z")

</div>

I just had a go at copying it - same error.

 ![Screen Shot 2022-01-29 at 2.32.06 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26b2fb643ed7f795eb0fc1398efc6c64b0795d48.png)

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 6:45am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/27 "2022-01-29T06:45:07Z")

</div>

Ah… this is strange. Well no answer yet from Support. Maybe they can fix it! Thanks for trying though…

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 6:59am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/28 "2022-01-29T06:59:15Z")

</div>

Just a thought, what happens if you try to copy my copy?!

> **[GOODBUY](https://jagged-liquid-2518.glideapp.io/)**
>
> Demo app: How to track items bought with Glide's BUY button using STRIPE

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2022, 7:16am UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/29 "2022-01-29T07:16:17Z")

</div>

Same error. Odd…

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [January 29, 2022, 1:23pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/30 "2022-01-29T13:23:31Z")

</div>

FWIW, I am following this, and I get the error copying, also. I have yet to get a Stripe account, but I am all ears…

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 29, 2022, 1:27pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/31 "2022-01-29T13:27:24Z")

</div>

I will release my template tomorrow, no extra fees, no problems with inventory adjustment, no problems with App crashing down

> **[Stripe buy button - DEMO](https://stripe-button-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AUwB0AHIAaQBwAGUAIABiAHUAeQAgAGIAdQB0AHQAbwBuACIALAAiAHIAIgA6ACIARwBiADgAdwBzAFkAZgBXAFIANABPAGUAOABSADAASwBOAGcAYgBXAGUAZwAiACwAIgBuACIAOgAiAFMAdAByAGkAcABlACAAYgB1AHkAIABiAHUAdAB0AG8AbgAiAH0A)**
>
> Customized Stripe button, no Glide fees, no PRO subscription, no Zappier or Integromat... writes back transaction info to Google Sheet, increment sold items.

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [January 29, 2022, 1:59pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/32 "2022-01-29T13:59:36Z")

</div>

Does this app have any experimental column? If so, remove them and try again.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2022, 3:09pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/33 "2022-01-29T15:09:59Z")

</div>

I was going to ask that question earlier, but then it occurred to me that if he did, then he wouldn’t have been able to make it copyable in the first place, right?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2022, 3:20pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/34 "2022-01-29T15:20:49Z")

</div>

@Simon_Hill I just noticed that even though I wasn’t able to copy your app, a copy of the Google Spreadsheet was created…

 ![Screen Shot 2022-01-29 at 11.16.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1aba79b1b36a698348345e9ce1c25e8960a7692a.png)

When I opened the sheet, I noticed that the formula is broken - obviously, because the `App: Sales` sheet doesn’t exist.

![Screen Shot 2022-01-29 at 11.18.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0fbb89d7443eb6266d2bcf72794958ad86a05ce0.png)

It’s quite possible that this might be tripping Glide up. So, a suggestion - try replacing that with a static header row and see if that makes any difference…

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [January 29, 2022, 3:25pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/35 "2022-01-29T15:25:24Z")

</div>

You are right, however I’m trying to diagnose what the cause of it may be.

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 3:47pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/36 "2022-01-29T15:47:05Z")

</div>

Hi guys - I was away for a while. Thanks for the suggestions. The formula discussed above is key to the spreadsheet working, but maybe if it’s blocking the copying then it can be pasted back in later. Perhaps Glide blocks anything that blocks a reference to a the hidden Sales sheet. Anyway let’s give it a go… I will post once the reference is deleted.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2022, 3:50pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/37 "2022-01-29T15:50:06Z")

</div>

My guess is that you could probably add a second sheet with a dummy header row, even if it’s just one column.

I think the problem might be that Glide can’t attach to the spreadsheet because there there are no sheets with a valid header row.

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 3:50pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/38 "2022-01-29T15:50:26Z")

</div>

Ok the App is now saved with the formula deleted. Can anyone try copying it now please?

Obviously if this works then the user will have to manually paste the formula back into Cell A1 of the tab Google Sheet called ‘SALES RECORDS’.

={‘App: Sales’!A:Z}

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 3:58pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/39 "2022-01-29T15:58:41Z")

</div>

I inserted ‘Temp header’ text into A1. Is that Ok Darren as a temp header row?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2022, 4:07pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/40 "2022-01-29T16:07:41Z")

</div>

Okay, I’m able to copy it now.  
But then it immediately complains about missing columns in the SALES RECORDS sheet.  
Which makes sense, because all those columns are missing.

I think there might be a bit of a chicken and egg situation here. Obviously, the `App: Sales` sheet doesn’t get copied when the app is copied, and I can understand why that would be the case. I’m not sure when that sheet gets created, but I guess it’s probably when you connect to Stripe. And because the copied app won’t initially be connected to Stripe, there is no `App: Sales` sheet. And so the formula to copy that sheet obviously won’t work.

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [January 29, 2022, 4:15pm UTC](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755/41 "2022-01-29T16:15:49Z")

</div>

Ok thanks for the persistence and diagnosis! I think you make a good point. I agree that the user needs to make at least 1 test payment with Stripe to finalize the app (when you click on the Buy button in the Glide editor it opens up ‘test payment’ links that can be used without using real money). Once done, it should be possible to paste the formula back into cell A1. Hopefully everything then works…!

[Previous page](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755.md?page=1)

[Next page](https://community.glideapps.com/t/lifetime-membership-access-how-to-access-app-sales/37755.md?page=3)
