I need a View created of encrypted Webform submissions for use by submission reviewers. The View should expose all submission data in a table with each column sortable.
The reviewers should be able to tag (via Taxonomy) and comment on each submission. My approach was to add these two additional fields to the Webform, but unset these when exposed to the user, and only show to appropriate roles or only in this View, etc. (exact implementation not too important as long as it's unset on the user-facing Webform).
– I'd like to be able to tag submissions from the table (via a select list), but if needed this can be done on the submission detail page
– There are also images and videos in one field (file upload); these are in the private file system. The actual video or image doesn't need to be shown on the table or submission detail page, just a link (but if it was integrated into either/both that would be great!
Some of the issues I've had:
- Getting Views to work with Webform submission data (needs to be 7.x-4.0-beta1 or you only get sid and links in submissions); fine to use 7.x-4.0-beta1 in solution
– Decrypting the data in the View (should be possible; the default Webform table does this just fine when browsing submissions); tried using a View template to decrypt() the data via the Encrypt module (which also encrypts the data), but was getting, "Notice: unserialize(): Error at offset 0 of 9 bytes in _encrypt_decrypt()"
Styling isn't needed, but it should take advantage of existing themes; for example I'm using Rubik, and the table in the View created should pull in styling from Rubik.
Compensation: $800 - $1000; based on responses received, timeliness (need ASAP if possible)
Please let me know if anything is unclear.