How to create editable list view divided into different number of months? Please HELP !!!
Hi, I want to create budgets module divided into months.
Something like this:
|January 2018||February 2018||March 2018||April 2018|
1. Editable in place, like in Excel. I've used List View and Editable parameter so it is done.
2. I want to have dynamic number of months. Different budgets have different number of months. Moreover it would be great to add new month to existing budget.
What I know?
I know that it is impossible to have dynamic fields, because tables in database are created earlier.
I'm setting maximum number of months. For example 36 months. If I need only 4 months I'm hiding remaining 32 fields. I'm creating a button to unhide next hidden column of month.
I'm making each budget value as object with value, budget line and month. For example in my table above I need first object with:
Month: January 2018
Budget line: Accomodation
Then I have to build my own view. I'd dont't know if it is good idea. I dont't even know where to start.
Use/modify some existing module. Maybe "2D matrix for x2many fields" module?
Please help me with some advise. Any hint will be much appreciated.
PS. I'm using Odoo 11 Enterprise.