Footer for list with ability to display calculated vlaues from column

usr338

Hi ,
I think it is useful to have footer for list.
In the footer any custom text or aggregation on columns or even better, calculation on columns value can be displayed.
Indeed i need to check equality of summary of two column and display appropriated message in footer.

gabriel

I am sorry, but your request is barely readable. Please take the time and properly write out what you want/need.

I can barely make out that you are talking about list aggregations - this feature we already have. But no idea what you mean with "equality of summary of two columns".

It would be best if you show an example use case and then explain why the current implementation does not fit your need.

usr338

gabriel
Hi and sorry again for my bad english. what i need is something like table with footer:

or this one :

or even do some calculation based on records in table(or list) and show result on footer.

gabriel

Your english is fine enough - just not thought out and with way too little context to work on.

To your request - do you mean something like this?

usr338

Yes, but I want to do this when designing the form so that when the user sees the list, the footer will show the result I want. I also want to show a custom text or do calculation using multiple columns and then show result in footer.

lsw-fabian

'Fixed' and customizable list footer are not available at the moment. You could work around it and place some read only fields under your list which are only serve as placeholders and fill them via frontend functions. But thats not a pretty way to achieve this.

We want to improve, what you can do with lists, in the future, (e.g. directly edit data in lists) and i will keep your suggestion - maybe we can implement such things.

TakadaGuna

Hello,

I have a question related to your suggestion. In the workaround suggestion, how to fill the placeholders via frontend functions? I don't know if we can read the values from a list because there is no field to read, in contrast to reading the value of form fields.

Right now I am calling the same list via backend function, do the calculations and then using the returned value to fill the placeholder. Is there a simple way to do this using frontend function only by reading values from a shown list ?

lsw-fabian

You can get the data you need via a backend function, triggered via frontend.
Of course this workaround has some limitation but it may be valid for some cases.