# Provide downloadable content

**URL:** https://community.glideapps.com/t/provide-downloadable-content/7287
**Category:** Ask for Help
**Created:** [April 18, 2020, 8:03am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287 "2020-04-18T08:03:05Z")
**Posts on this page:** 19
**Page:** 1

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [April 18, 2020, 8:03am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/1 "2020-04-18T08:03:05Z")

</div>

Hello. I don’t know which category this falls under.

I am giving time limited access to customers based on the plan they pay for. E.g 6 months, 2 years or forever. Now, at the end of the service period, I would like to give customers some sort of downloadable artifact of their content. Like a PDF or compressed folder of multiple files. The content is like a web page with text, images and formatting. Customers will get an email with attachment or link with their content package.

How can I do this? I am thinking writing some sort of script function. Any suggestions?

---

<div class="post-metadata">

### Author: ![Falcor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/falcor/32/3166_2.png) [@Falcor](https://community.glideapps.com/u/Falcor)
#### Post date: [April 18, 2020, 5:34pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/2 "2020-04-18T17:34:52Z")

</div>

Do you think about making a google sheet formula that changes number of days last?  
When the number is 0 or under 0 you have a filter to show a link or some information.

---

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [April 19, 2020, 12:50pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/3 "2020-04-19T12:50:14Z")

</div>

Got that but how would I generate downloadable content?

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [April 19, 2020, 1:49pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/4 "2020-04-19T13:49:48Z")

</div>

What do you want the user downloading?Is it just a webpage, several files? Or a glide screen?

---

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [April 20, 2020, 5:55am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/5 "2020-04-20T05:55:28Z")

</div>

Some options I am considering are:

1. A well formatted PDF with links to media that point to files in a sub-directory
2. An offline web page with links to media that point to files in a sub-directory
3. A compressed file with folders having media categories

My media is pictures, videos, audio clips, documents, plain text notes.

---

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [July 6, 2020, 7:39pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/6 "2020-07-06T19:39:59Z")

</div>

Can anyone suggest how to achieve this? Thanks.

---

<div class="post-metadata">

### Author: ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)
#### Post date: [July 6, 2020, 7:58pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/7 "2020-07-06T19:58:48Z")

</div>

Please do you have any ideas because I have always wanted something like this

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [July 7, 2020, 9:26am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/8 "2020-07-07T09:26:56Z")

</div>

Is this content uploaded via the Glide app?

---

<div class="post-metadata">

### Author: ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)
#### Post date: [July 7, 2020, 9:45am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/9 "2020-07-07T09:45:57Z")

</div>

in my case yess

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [July 7, 2020, 9:59am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/10 "2020-07-07T09:59:33Z")

</div>

So the links to these files are stored within your sheet. You can def use Apps Script to email users their uploaded content, but with the inevitable variables that come with this use case, we will need some magic for sure. Ideally, what flow do you envision?

1. Users can request their content via the app and receive an email?
2. Manually send content upon request?

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [July 7, 2020, 12:21pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/11 "2020-07-07T12:21:05Z")

</div>

You can create an Amazon S3 bucket containing your archive or your files, for this purpose. You’ll get a downloadable link you can integrate in your app as a web link

---

<div class="post-metadata">

### Author: ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)
#### Post date: [July 7, 2020, 1:11pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/12 "2020-07-07T13:11:34Z")

</div>

that sounds a lot easier

---

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [July 7, 2020, 6:53pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/13 "2020-07-07T18:53:32Z")

</div>

@MegannLock, in my case it is basically when a subscription ends and is not renewed. I want to hand the user what they had in a good formatted way. Similar to how you get your pictures taken in a studio and they give you a photo DVD. How someone requests it is not really important for me.

Ideally, I want to give them a formatted PDF document with links pointing to local folders/sub-folders in the same directory.

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [July 8, 2020, 2:05pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/14 "2020-07-08T14:05:17Z")

</div>

I asked that because I’m wondering if you’re after an automated system. If not, then you can always grab their file upload links from your google sheet and place them into a template of some kind.

If you’re wanting an automated system, then google apps script would be a solution. I’m a mere amateur with scripts, but I have written one that creates a PDF of a specific tab of a sheet & emails it. So, it could be modified to fit your needs. Are you familiar with Apps Script?

---

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [July 8, 2020, 5:32pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/15 "2020-07-08T17:32:55Z")

</div>

Yes. I use scripts extensively. Could you guide me with the pdf solution. I want to automate this workflow. Thanks

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [July 8, 2020, 5:47pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/16 "2020-07-08T17:47:18Z")

</div>

Sure! I’ll comment some links/examples here in a bit!

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [July 8, 2020, 10:10pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/17 "2020-07-08T22:10:20Z")

</div>

Okay check out this sheet+script for some ideas— it’s not fully automated, but that’s where your creativity can flourish! Since you’re experienced with apps scripts, you might play around with the embedded script and add additional functions to automate it more. The tab labeled “PDF” contains some formulas to filter one indicated user’s files from two diff tabs. In this example, I just used hyperlinks for the files, but you could very well use an image formula to actually display them depending on the content type.

Hope this helps (auto-copy link): [https://docs.google.com/spreadsheets/d/1HWNwbxEZkNPf9hQJMDMimPixi4Ig2N8ZUK1shXk\_y5o/copy](https://docs.google.com/spreadsheets/d/1HWNwbxEZkNPf9hQJMDMimPixi4Ig2N8ZUK1shXk_y5o/copy)

---

<div class="post-metadata">

### Author: ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)
#### Post date: [July 8, 2020, 10:34pm UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/18 "2020-07-08T22:34:46Z")

</div>

Also, I threw/recycled this together rather quickly. I think I may have forgotten to change the script to email just that first tab! Oops!

---

<div class="post-metadata">

### Author: ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)
#### Post date: [July 9, 2020, 2:18am UTC](https://community.glideapps.com/t/provide-downloadable-content/7287/19 "2020-07-09T02:18:19Z")

</div>

Thanks so much for helping out. I will take a look in a day or two.
