Friday, 29 September 2017

SPServices : How to update SharePoint list item?


$(document).ready(updateListItem(12,"Next3"));

function updateListItem(itmeID,newTitle) {
 
    $().SPServices({
        //webURL: "https://domain/site_coll/site/",
        operation: "UpdateListItems",
        valuepairs: [["Title", newTitle]],
        async: false,
        listName: "Test List",
        ID: itmeID,
        completefunc: success_updateListItem
    });
 
}

function success_updateListItem(xData, status) {
alert(status);
}

Thursday, 28 September 2017

SPServices: How to fetch filtered SharePoint list items?


$(document).ready(getListItems);

function getListItems() {
 
    $().SPServices({
        //webURL: "https://domain/sites/site_collection/site",
        operation: "GetListItems",
        async: false,
        listName: "Test List",
        CAMLViewFields: "<ViewFields Properties='True' />",
        CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title' /><Value Type='Text'>YourValueHere</Value></Eq></Where></Query>",
        completefunc: success_getListItems
    });
 
}

function success_getListItems(xData, status) {
$(xData.responseXML).SPFilterNode("z:row").each(function () {
                var liHtml = "<li>" + $(this).attr("ows_Title") + "</li>";
                $("#tasksUL").append(liHtml);
            });
}

SPServices: How to fetch SharePoint list items with all fields?



$(document).ready(getListItems);

function getListItems() {
    $().SPServices({
        //webURL: "https://domain/sites/site_collection/site",
        operation: "GetListItems",
        async: false,
        listName: "Test List",
        CAMLViewFields: "<ViewFields Properties='True' />",
        completefunc: success_getListItems
    });
}

function success_getListItems(xData, status) {
$(xData.responseXML).SPFilterNode("z:row").each(function () {
                var liHtml = "<li>" + $(this).attr("ows_Title") + "</li>";
                $("#tasksUL").append(liHtml);
            });
}

Friday, 15 September 2017

How to create week wise list views in SharePoint?


To create week wise list view in SharePoint list follow the following steps.

Step 1. Create a calculated column named 'WeekStart' of type Date with the following formula:

=IF(TEXT(WEEKDAY([Created]),"ddd")="Mon",[Created],(IF(TEXT(WEEKDAY([Created]-1),"ddd")="Mon",[Created]-1,(IF(TEXT(WEEKDAY([Created]-2),"ddd")="Mon",[Created]-2,(IF(TEXT(WEEKDAY([Created]-3),"ddd")="Mon",[Created]-3,(IF(TEXT(WEEKDAY([Created]-4),"ddd")="Mon",[Created]-4,(IF(TEXT(WEEKDAY([Created]-5),"ddd")="Mon",[Created]-5,[Created]-6))))))

Step 2. Create a calculated column named 'WeekEnd' of type Date with the following formula:

=IF(TEXT(WEEKDAY([Created]),"ddd")="Sun",[Created],(IF(TEXT(WEEKDAY([Created]+1),"ddd")="Sun",[Created]+1,(IF(TEXT(WEEKDAY([Created]+2),"ddd")="Sun",[Created]+2,(IF(TEXT(WEEKDAY([Created]+3),"ddd")="Sun",[Created]+3,(IF(TEXT(WEEKDAY([Created]+4),"ddd")="Sun",[Created]+4,(IF(TEXT(WEEKDAY([Created]+5),"ddd")="Sun",[Created]+5,[Created]+6))))))


Step 3. Create a new view to filter the items based on the following criteria:

WeekStart < [Today] < WeekEnd.


Following can be used to create a previous week view: WeekStart < [Today]-7 < WeekEnd. Similarly following for next week WeekStart < [Today]+7 < WeekEnd.