Get Survey Ino

jtandrew · **Joined:** Mon Jun 07, 2010 4:42 pm **Posts:** 6

Hi all,

Here is the scenario that I have. I have a multiple step Survey that will be filled out my multiple users multiple times. After a user has filled out the first page I would like the value for a Vendor/Supplier to show at the top of each of the edit pages from that point on.

I have come to the following conclusions:

Use jQuery and SPServices
Use the GetListItems operation
Use the ID that is appended to the Query string to query the list and get the value that was entered on the first page

Two issues that I am running into:

How can I pull the ID from the query string? Is something like this correct?
Code:
var ID = $(this).attr("ows_ID");
Once I have the ID how can I pull back just that record to get my needed value for display?

I am looking to display something like this at the top of the survey.
Vendor: Georgie

Thanks for all previous, current and future help!!! Jim

jtandrew · **Joined:** Mon Jun 07, 2010 4:42 pm **Posts:** 6

Thanks to Jim Bob on another post that I made I was able to figure this out. See the code below:

Code:

<script type="text/javascript">
$(document).ready(function() {


    var SurveyID = getQuerystring('ID');
    var SupplierName = null;

    $().SPServices({
       operation: "GetListItems",
       async: false,
       listName: "Supplier Questionnaire", // Use Display Name of your survey list
       CAMLQuery: "<Query><Where><Eq>" +
                        "<FieldRef Name='ID' />" +
                        "<Value Type='Integer'>" + SurveyID + "</Value>" +
                       "</Eq></Where></Query>",
       completefunc: function(xData, Status) {
           SupplierName = $(xData.responseXML).find("[nodeName='z:row']").attr("ows_Which_x0020_Supplier_x0020_would");
                                     // Prepend 'ows_' to the StaticName of the Lookup column in your survey list
       }
    });
$('#Supplier').append('<strong>Supplier you are reviewing: ' + SupplierName + '</strong>');
});


function getQuerystring(key, default_)
{
  if (default_==null) default_="";
  key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
  var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
  var qs = regex.exec(window.location.href);
  if(qs == null)
    return default_;
  else
    return qs[1];
}



</script>
<div id="Supplier"></div>

Stump the Panel: SharePoint Q&A

Forum rules

Get Survey Ino

Who is online