Tuesday, June 7, 2016

GetListItem and UpdateListItem using SPServices in MOSS 2007

GetListItem and UpdateListItem using SPServices in MOSS 2007

$(document).ready(function() {
var itemToUpdate = GetListItem();
UpdateListItem(itemToUpdate);
});

function GetListItem(){

var today = new Date();
var dayOfWeek = today.getDay();
var itemID = 0;
var out = "";

var titleField = "<FieldRef Name='Title' />";
var descriptionField = "<FieldRef Name='Description' />";

var viewFields = "<ViewFields>" + titleField + descriptionField + "</ViewFields>";
var myQuery = "<Query>" +
"<OrderBy>" +
"<FieldRef Name='ItemOrder' Ascending='True'/>" +
"</OrderBy>" +
"</Query>";

$().SPServices({
operation: "GetListItems",
async: false,
listName: "MyList",
CAMLQuery: myQuery,
  CAMLViewFields: viewFields,
completefunc: function (xData, Status) {
var activeItemAvailable = false;
$(xData.responseXML).SPFilterNode("z:row").each(function() {
strTitle = $(this).attr("ows_Title");
strDescription = $(this).attr("ows_Description");
itemID = $(this).attr("ows_ID");
});

$("#divID").html(out);
}
});
return itemID;
}

function UpdateListItem(itemToBeUpdated)
{
var today = new Date();
var lastTuesdayDate = today.GetLastTuesdayOfWeek().toISOString();
$().SPServices({
operation:"UpdateListItems",
async: false,
listName: "MyList",
ID: itemToBeUpdated,
valuepairs:[["IsActive", true], ["DateMadeActive", lastTuesdayDate]],
completefunc:function(xData, Status)
{
}
});
}

Date.prototype.GetLastTuesdayOfWeek = function() {
    return (new Date(this.setDate(this.getDate() - this.getDay() + 2)));
}

Populate people picker field with logged in user in SharePoint using JS

Please use below code to populate people picker in SharePoint online, <script src="https://ajax.googleapis.com/ajax/libs/jquery/3....