Webforms added the "Serial" value to the webforms_submissions table earlier this year. Recommend making this value available as a default meta component similar to how Submitted By User, Submission Date, Submission Time and Submission IP Address are made available in Webform Report columns selection. This would be helpful for reporting out a unique value assigned to each draft/saved webform submission. This is the value that's used on the Webform results page to identify the "#" of each submission.

Reference: https://www.drupal.org/node/2041221

This is an awesome module, a labor saver. Thanks for making it!

CommentFileSizeAuthor
#3 interdiff-2390079-1-3.txt3.25 KBdtroxell
#3 webform_report-add-serials-2390079-1.patch3.88 KBdtroxell
#1 add-column-serial-value-2390079.patch1.44 KBsrutland
WebformsSubmissionTable-MySQL.png22.13 KBsrutland
WebformResultsPage.png85.69 KBsrutland

Comments

srutland’s picture

srutland commented
StatusFileSize
new add-column-serial-value-2390079.patch1.44 KB

Created a patch to allow report authors to add a column that displays the Serial value uniquely assigned to each Webform submission. It only allows a display column, it is does not provide for Filters or Sort by.

I'm not a PHP/MySQL expert and this is my first patch (got some friendly consulting help), but this patch allows our users to visually associate serial values in a WF Report with the actual Webform results.

tmedlen’s picture

tmedlen commented

This patch works for me, was much needed- thanks

dtroxell’s picture

dtroxell commented
Status: Active » Needs review
StatusFileSize
new webform_report-add-serials-2390079-1.patch3.88 KB
new interdiff-2390079-1-3.txt3.25 KB

Created a patch that expands upon srutland's by making the added serial meta component a number rather than a string. Also adjusts the indexing of the meta components to allow serials to be included in the search dropdown, the filters, and the sort ons.