I have this table that I want to use as a money tracker
The goal is to list transactions updating the available ammount dinamically. So, given the initial value, in the rows above the “total” column should be updated.
It should be =thisRow.value + previousRow.value. Yeah, I know there is no such thing as previousRow. So how can I accomplish that?
How it works:
It basically checks if you are currently in the first row.
If yes, it just takes the value of the value column.
If not, it adds the value of the current row to the total of the last row.
To do this, it needs a reference to the last row - thats why we need the Real ID
I think the row number vs. row id is one of the critical differences between a spreadsheet table and a database table. Both, number and id, makes sense in a lot of use cases, but I guess it is hard to combine them without confusing users.
But users can already be confused for simple tasks. That’s my case sometimes, and I already have experience with Coda.
I’m afraid that those kinds of workarounds instead of straight comprehension would let new users disappointed. This is what I can read on productivity forums. People thinks that Coda is aimed for power users and devs.
I am late to the party but I have the following idea:
A function which can be implemented from Coda is the cumulative sum function - it also fulfils Coda’s design requirements since it is not a cell based function.
Nice having you in our community.
If you want to “copy/paste” info from one to another table you could use a button that first filters out the data you want to extract and then places this to the table of your choice
This is one of the articles that references:
Many more great articles and support you will be able to find in this community