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. […

[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…

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 tha…

@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	1162	May 4, 2022
How to create a cumulative sum of rows in a columns Ask for Help	14	2287	November 24, 2023
Glide Pages and Rollup for rows and columns Ask for Help	3	390	January 7, 2023
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	18	1071	July 15, 2023
🙏😍 Add Query function to Glide Tables, Please! Feature Requests	26	2869	March 19, 2024

GlideApps Collection Ledger Format

Related topics