Copy data from Table to Custom Object
Is it possible to have OSC copy data from a table (kf_social_question_stats) into a Custom Object (Community Question)? I want the custom object to always reflect this stats table so want the data population to occur automatically rather than via manual effort or external script.
The reason behind this is that I am trying to write a widget for the Community SS to show how may views a particular question has had, but the community question view data (kf_social_question_stats) is not visible to ROQL/fetch. The only way I can think of doing this is via copying the data into a custom object.