# GlideApps Collection Ledger Format
**URL:** https://community.glideapps.com/t/glideapps-collection-ledger-format/61622
**Category:** Ask for Help
**Created:** [May 11, 2023, 7:21am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622 "2023-05-11T07:21:16Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [May 11, 2023, 7:21am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/1 "2023-05-11T07:21:17Z")
Hello all, I have been struggling with this feature in GlideApps, this is the feature I want to achieve:
In an normal accounts ledger for party ‘X’, there are a list of transactions along with the date, transaction ID, amount and net effect, as shown below. Kind of like a monthly bank statement.
_ **I want to know how to produce the net effect for each row in a glide table** _
It’s easy to achieve this in a spreadsheet as you can use formulas to have each cell reference the surrounding cells yet I do not know how to tackle this within GlideApps’s Glide Tables. My data in Glide is as shown below.
@ThinhDinh
@Darren_Murphy
Others, please provide your input too!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 11, 2023, 7:24am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/2 "2023-05-11T07:24:11Z")
> [@Running Totals](https://community.glideapps.com/t/running-totals/41596/2):
>
> Here are the steps to do it exclusively within Glide. Add a rowID column. Add an IDs array: lookup all rowIDs within this table. Add an index column, use the plugin Array \> Find Element Index. Add a template column to lock in the format of the number. Add a joined list column to join all the “template” numbers. Add a JavaScript column to calculate the running total using the list of numbers and the index of each row. le…
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [May 11, 2023, 7:28am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/3 "2023-05-11T07:28:03Z")
Wow! That’s brilliant mate! Thank you so much!
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [May 11, 2023, 7:40am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/4 "2023-05-11T07:40:29Z")
@Darren_Murphy Just checked. This seems to work only in Glide Tables and not Glide Big Tables. Is this true?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 11, 2023, 7:49am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/5 "2023-05-11T07:49:43Z")
That’s quite possible, especially if you have multiple relations involved.
I haven’t tried this myself in a GBT, so it’s something I would need to experiment with.
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [May 11, 2023, 7:53am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/6 "2023-05-11T07:53:39Z")
@Darren_Murphy So would a normal Glide table be able to hold about 1 million rows of data over 14-16 months just containing rows with inventory in out data?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 11, 2023, 8:08am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/7 "2023-05-11T08:08:00Z")
Putting row limits aside, I’d expect that you could load 1 million rows in a normal Glide Table, yes.
But getting 1 million rows to load on a users device (or even in the Glide builder) is a completely different matter.
But let’s not put the cart before the horse. It hasn’t yet been determined that what you want to do cannot be done in GBT. And I expect that it probably can be done. When I have some time, I’ll have a play with it, and will come back to you if I come up with a solution.
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [May 11, 2023, 8:19am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/8 "2023-05-11T08:19:13Z")
@Darren_Murphy Thank you! I will perform some trials myself as well
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [May 12, 2023, 8:19am UTC](https://community.glideapps.com/t/glideapps-collection-ledger-format/61622/9 "2023-05-12T08:19:22Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.