View Individual Survey Responses

[alaroche]

Does anyone know how to create/view the response details page for a individual user who would have registered to take a survey? The user is not logged into Checkbox at the time they would view this, I am actually trying to display this within a seperate system. I am trying to allow a user on a system linking into the Checkbox tables to view their answers for a particular survey by providing the username (or unique identifier) and the survey number. The existing system is written in asp. Please help!

[ncushing]

The screen itself only requires the Guid from the ckbx_Response table as the parameter to show the response.

The link would look like:

ViewResponseDetails.aspx?ResponseGuid=[RESPONSE_GUID]&NoChrome=true

You would replace [RESPONSE_GUID] with the guid for the response. The NoChrome portion tells the page not to display the Checkbox navigation icons, etc. and just to display the response details.

The second issue you have to deal with is the security on the page, which verifies that the user requesting the page has proper permissions on the survey to view individual responses. The first option here is to edit the permissions of the survey to add "View Response Details" permission.

Another option is to make use of the ticketing mechanism built in to the page that is used to allow respondents to view their response via the Display Response survey item.

To create a ticket in the database, you can run:

ckbx_Ticket_Insert [RESPONSE_GUID], [TICKET_EXPIRATION]

[TICKET_EXPIRATION] is the DateTime that the ticket for the particular response will cease to be valid.

-Noah