How can i recreate this is glide tables? Everyone’s initial balance should be 0, then for the succeeding rows (in which case user should have had at least 1 previous transaction) - the starting balance should be the previous end balance.
side note: i was actually able to make the calculations work (including the +/- and only when status is “approved”) - but the display on the data table is incorrect, since as a workaround, i had to make the startbal a lookup that fetches the previous endbal, so it looks like this:
- Make sure you record the user’s ID/email.
- Use a query column, filter by user’s ID/email equals to this row > user’s ID/email.
- Add a rowID column to your table.
- Add a lookup column on top of the query result, pointing to that rowID column, so you get an array of IDs for the same user.
- Add a find element index column, use the lookup result as the base, and look for the current row’s rowID. You will get a 0-based list of index for each user.
- Add a math column, with the formula being: I-1, with I being the index of the current row. This will give you the index of the previous row from the same user.
- Add a query column, use the query from the 2nd step as a base, filter by index equals to this row > previous row’s index.
- Add a single column to fetch the first “EndBal” from the query above.
Now you got the EndBal from the previous row, you can proceed with calculating other things within your structure.
whoa! that’s a lot! will do my best to make it work. thanks again
