Customer login  |   Contact us
Home Company Products Support Purchase
Forum Home » Survey software » Opinio

Topic: Tracking Responses
Replies: 1   Pages: 1  

Back to Topic List Back to Topic List Topics: [ Previous | Next ]
Replies: 1   Pages: 1  

Posts: 1
Registered: Jul 24, 2015
Tracking Responses
Posted: Jul 24, 2015 7:32 PM


Im new at using Opinio.

Is it possible for me to create an ID for each survey that I send out so that when I receive the responses, I can identify who it is from?



Posts: 72
From: London
Registered: Aug 26, 2005
Re: Tracking Responses
Posted: Oct 6, 2015 3:43 PM

You need to use the Execute Select plugin (available to download in the Plugin Central part of the Opinio website).

The following will display the ID and Key details of all participants of a specific survey (you need to change the Survey ID at the end of the expression to the ID of the survey you are interested in):

SELECT a.InvitationID, b.IDKey, b.InviteeEmail, b.InviteeId FROM OPS_Invitation a, OPS_Invitee b WHERE b.InvitationID = a.InvitationID AND a.SurveyID = 5453

© 1998-2019 ObjectPlanet, Inc. Øvre Slottsgate 5, 0157 Oslo, Norway Tel (+47) 2233 3360 | Fax (+47) 2233 3361