Updateable Pivot Table: Possible?
838924Feb 11 2011 — edited Feb 12 2011Hi,
I am trying to find the right technology for a web based app I am goin' to write. I have done a great deal of apex development before. Now what I need at some point of time is a possibility to have a pivot table with updatable fields in it. Both rows and columns will be dynamic. Now I know this is gonna be a more complex task but I guess my question is is this possible in the first place?
To give you an example I will have a table with people and one with skills. In a third table I will join these together probably using a numerical value to assign the level of skill. A manager looking at their respective direct reports should now see a list of the people with a column per skill. This table now should be updatable with the above mentioned numeric value. From a useability standpoint it would be quite painful to go through every single employee individually and update the values per skill in there.
( Maybe already some ideas on how to do this? :-) )
Thanks for your help!
Henrik