nextcloud
Feature request: calculated columns
This is a feature request to add a numeric column type which is calculated from other number columns. It would be a formula where you can reference other columns.
There are various stages/levels to which this could be implemented
Level 1: allow formulas containing only plain number column values, I.e. not other columns of this calculated type
Level 2: also allow other calculated numeric columns as input, more like a spreadsheet
OK going crazy
Level 3: return result of python (or similar) script acting on the other numeric columns as input. Probably best in this case to work on whole column I put, and ensure script return whole column of numbers back.
There are many use cases, e.g. customer CRM pipeline where deal value is %success of stage * total deal value
Well, I change this issue to a generic "calculated columns" to track this feature. Unfortunately it's not planned for the first version.
This might also be just available in the view, perhaps an easier use case.
To collect a possible use case:
- have a GitHub url in one column, extract meta columns calculated for information from the link, like issue state, assigned user, repository
