# Count downloads and update without opening spreadsheet

**URL:** <https://community.glideapps.com/t/count-downloads-and-update-without-opening-spreadsheet/3095>\
**Category:** Feature Requests\
**Created:** [December 23, 2019, 11:46am UTC](https://community.glideapps.com/t/count-downloads-and-update-without-opening-spreadsheet/3095 "2019-12-23T11:46:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![De\_Deus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/de_deus/32/2214_2.png) [@De\_Deus](https://community.glideapps.com/u/De_Deus)\
**Post date:** [December 23, 2019, 11:46am UTC](https://community.glideapps.com/t/count-downloads-and-update-without-opening-spreadsheet/3095/1 "2019-12-23T11:46:36Z")

</div>

Good morning people, everything fine? This ([https://dedeus.glideapp.io](https://dedeus.glideapp.io)) is my first app and I need help in two situations …  
First: I have a download section and would like to count how many times a particular image is downloaded. Is it possible?

 ![Screenshot_20191223-083126_Chrome](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9a86d9a866288ee96a9a88a97f85340fca16d46c.jpeg)  
Second: I searched the group, but I couldn’t find the solution. I have a “Devotional” tab and a spreadsheet with a Today () formula, but when the day comes, it doesn’t update in the app. Only updates if I open the spreadsheet … then yes updates.  
 ![20191223_084140](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d86f3cdd069f6d83388eba1b605fcf8fb2c29a2f.jpeg)  
Is there any way to update automatically if I have to keep opening the spreadsheet?

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [December 23, 2019, 12:49pm UTC](https://community.glideapps.com/t/count-downloads-and-update-without-opening-spreadsheet/3095/2 "2019-12-23T12:49:23Z")

</div>

Your best bet in my opinion is to use a Google trigger to run a simple function overnight that could do whatever you want in regard to what your Today() formula is doing. Here is the Google Doc on [Triggers](https://developers.google.com/apps-script/guides/triggers/installable), but there are a ton of tutorials on YouTube.

As for question 1, I did a quick google search on “file sharing site with download statistics” and came up with [http://ge.tt/](http://ge.tt/) . I have never used them but it looks like it will do what you want and comes with 2gig of storage for a free account.
