All RPGs and Storygames by Tod Foley are now available at DrivethruRPG and RPGnow. Bring these games to your table!
When the Queen Latifah show needed an interface for browsing and annotating viewer submissions including both images and video, AIP was brought in by Digital Kitchen to provide it. The interface, hidden from public view, allows show producers to search and sort through hundreds of submissions arriving daily, and to share notes on which submissions might make good guests for the show.
To get this system off the ground it was first necessary to migrate several hundreds thousand submissions from the Webform format to the more robust Entity format, allowing search indexing and fully-featured Drupal fields to be applied to them. The interface was then built using a combination of Views and custom code, with a lot of jQuery-driven event handling for dynamic effects and inline editing.