I hope some of you will be able to help me out. Otherwise I am afraid my bubble journey ends
The basic requirements are:
- Allow for user specific calculation of EV charging costs
- Combine data from multiple data types
- Visualise in a repeating group or table
- Be able to sort on the dynamic calculated values (i.e. no field in DB)
I have tried multiple different solutions but none of them seems to be able to allow all of the needed functionality. Below is an overview of where the solutions miss out (at least as far as I know):
I have not tried to setup a solution where the calculations are stored to the DB as I would think it would be too massive amount of data to save as the number of different charging solutions is over 50 and will only increase in time. I believe it would require a record for each unique combination of each user/charging solution. However, if this is actually a viable solution please let me know the the best approach of creating such combinations dynamically as it would immediately allow me to use a RG with normal sorting functionality.
I have tried to describe below how the setup and the expected outcome is. There are more complex calculations being done in the final product but this should show the basic needs.
Thanks for any help you are able to provide.
All the best