You still have to manually assign each expense from table A to the correct row in table B but given that we don’t auto-generate rows this is sort of to be expected in order to have one row per category.
thanks for providing an example. In your table A, the “category” field doesn’t play a role, programmatically, correct ? I tried to replicate this setup and with every new expense, I would have to modify the “Link to expenses” field manually, correct ?
If that’s the case, I think i’m still better served having a single table, and filtering by category when needed (and also has the benefit of being able to filter by category + time period, useful for accounting).
Ultimately I’d love to have group-by functionality the same as airtable, but I understand it’s still some time away on the baserow roadmap.
I would have to modify the “Link to expenses” field manually, correct ?
Yes that’s right.
In fact the rollup field is just a fancy wrapper for something that was already possible with our formula language by using sum and lookup but since not everybody wants to go deep enough into Baserow to learn how the formula language works we decided to provide a more accessible field type that does the same thing.
Separately, I noticed creating a new row is faster in 1.18. It used to be that if you quickly did shift+enter and then pasted text, you’d get an annoying error presumably as the backend was busy creating the new row. It’s much harder get that error now.