# Create a Financial Record Keeper

**URL:** <https://community.glideapps.com/t/create-a-financial-record-keeper/1774>\
**Category:** Ask for Help\
**Created:** [November 7, 2019, 3:11pm UTC](https://community.glideapps.com/t/create-a-financial-record-keeper/1774 "2019-11-07T15:11:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew\_Wheelock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_wheelock/32/1374_2.png) [@Andrew\_Wheelock](https://community.glideapps.com/u/Andrew_Wheelock)\
**Post date:** [November 7, 2019, 3:11pm UTC](https://community.glideapps.com/t/create-a-financial-record-keeper/1774/1 "2019-11-07T15:11:57Z")

</div>

Hi everyone, First time user here so I hope this is an appropriate question.

Here’s what I would like to do:

I have a google Form with two questions.  
Student Number  
Money added or subtracted

I want to have the the data organized by the student number and the additions/ subtractions automatically tabulated.

So if I search for a student they will see their total money.

Easy? Hard? Can you help me?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 7, 2019, 3:26pm UTC](https://community.glideapps.com/t/create-a-financial-record-keeper/1774/2 "2019-11-07T15:26:48Z")

</div>

Check out the Currency Transfer/Purchase example in [https://concepts.glideapp.io/](https://concepts.glideapp.io/) . You can copy the app and look at the sheet. It should have the formulas to do what you want.

---

<div class="post-metadata">

**Author:** ![Andrew\_Wheelock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_wheelock/32/1374_2.png) [@Andrew\_Wheelock](https://community.glideapps.com/u/Andrew_Wheelock)\
**Post date:** [November 7, 2019, 3:27pm UTC](https://community.glideapps.com/t/create-a-financial-record-keeper/1774/3 "2019-11-07T15:27:24Z")

</div>

Thank you so much… I will give it a try!

---

<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:** [November 7, 2019, 3:28pm UTC](https://community.glideapps.com/t/create-a-financial-record-keeper/1774/4 "2019-11-07T15:28:57Z")

</div>

Whether its easy or hard would depend on your skill level with Google Sheets. Why don’t you create the app with what you know and then share your sheet and ask for help with creating the formula(s) you may need. Off hand I would think it would involve the SUMIF() function but I’m sure there are many ways to pull it off. Have you tried to duplicate any of the tutorials to get an idea of Glide. This latest one is especially good for a complete start to finish app.