Is there a way I can display calculated fields on a table?
For example, I have a table block that shows several orders with their dates and number of products. How can I show a column with the number of days since the order was made? Or is there a way to show a line at the bottom with a sum of all the products,so that I can filter by dates or customers and see the total for them?
If not possible to do in a table, what could be another approach to produce those statistics?
We are developing Summary plugin for table.
Thank you for your reply. That plugin will simplify things a lot.
In the meantime, is there a way to show calculated fields in a table? If there is not, how can I calculate and show some statistics? I can make a workflow using the aggregate function, but have no idea of how to display those results.
For sub-tables (association record), you can create a field in the parent collection to store the aggregated results of the child collection.
Summary Fields for table relationships is a requirement for my use case. Any rough idea of a timeline for a plugin for this? Namely, I need a parent field to show how many child records there are. I also need no be able to use child (or parent) field values in the Formula field depending on the direction of the one-to-many relationship.