# How to track patronage of businesses on the app

**URL:** <https://community.glideapps.com/t/how-to-track-patronage-of-businesses-on-the-app/34825>\
**Category:** Ask for Help\
**Created:** [November 20, 2021, 8:09pm UTC](https://community.glideapps.com/t/how-to-track-patronage-of-businesses-on-the-app/34825 "2021-11-20T20:09:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SRblackbird](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@SRblackbird](https://community.glideapps.com/u/SRblackbird)\
**Post date:** [November 20, 2021, 8:09pm UTC](https://community.glideapps.com/t/how-to-track-patronage-of-businesses-on-the-app/34825/1 "2021-11-20T20:09:59Z")

</div>

I am building a directory of businesses that are owned by members of an alumni group. In exchange for being on the app businesses will donate a percentage of revenue the app generates for them to the alumni group.

-How could the app let consumers upload a copy of a receipt and enter the amount spent? That part I think I can figure out.

-Have the total spent by all consumers of a particular business be totaled for the month or quarter and shared with the business.

-Generate a graphic (thermometer, bar graph, etc.) That shows the total amount donated to the alumni group from all businesses on the app.

Thanks for any help or suggestions.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 20, 2021, 9:04pm UTC](https://community.glideapps.com/t/how-to-track-patronage-of-businesses-on-the-app/34825/2 "2021-11-20T21:04:25Z")

</div>

> [@SRblackbird](#):
>
> -Have the total spent by all consumers of a particular business be totaled for the month or quarter and shared with the business.

In the list of receipts, create columns that generate a unique quarter or month+year code using math and ITE columns.

Then, you’ll be able to create relations from a selected month/quarter to those entries for rollup purposes

> [@](#):
>
> -Generate a graphic (thermometer, bar graph, etc.) That shows the total amount donated to the alumni group from all businesses on the app.

After the part above, use quickChart or Glide’s built in charts to display these values.