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. [Screenshot 2023-05-11 at 12.47.50 PM] 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. [Screenshot 2023-05-11 at 12.38.55 PM] @ThinhDinh @Darren_Murphy Others, please provide your input too!

[image] Running Totals Ask for Help [image] Here are the steps to do it exclusively within Glide. Add a rowID column. Add an IDs array: lookup all rowIDs within this table. [image] Add an index column, use the plugin Array > Find Element Index. [image] Add a template column to lock in the format of the number. [image] Add a joined list column to join all the “template” numbers. [image] Add a JavaScript column to calculate the running total using the list of numbers and the index of each row. [image] le…

Wow! That’s brilliant mate! Thank you so much!

@Darren_Murphy Just checked. This seems to work only in Glide Tables and not Glide Big Tables. Is this true?

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.

@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?

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.

@Darren_Murphy Thank you! I will perform some trials myself as well

GlideApps Collection Ledger Format

Ask for Help

Darren_Murphy May 11, 2023, 7:24am 2

Topic		Replies	Views
Running Totals Ask for Help	3	1199	May 4, 2022
How to create a cumulative sum of rows in a columns Ask for Help	14	2378	November 24, 2023
Glide Pages and Rollup for rows and columns Ask for Help	3	408	January 7, 2023
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	18	1191	July 15, 2023
🙏😍 Add Query function to Glide Tables, Please! Feature Requests	26	2992	March 19, 2024

GlideApps Collection Ledger Format

Related topics