Hi, I model my data in a three-column table like the one below. The three columns are [Month], [ProductionType] and [Production]. [Day] and [ProductionType] together are the primary key.
I would like to input data in an Excel like grid form like the one below. Note that this is not a pivot table because there is only one record at the intersection of a production type and a month.
Did some form control exist in Apex to input data in this way. If not, what’s the best way to input this kind of data considering that I have more than 12 months and more than 2 Production type ?