Sharepoint Rocks

August 2026
M	T	W	T	F	S	S
	1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31

Expand/Collapse Table Rows With jQuery

Posted: October 31, 2020 in SharePoint2013

First Option for expanding/collapsing HTML table row

A common UI will have an HTML table of data rows. When we click on “Expand”, it shows a detailed breakdown of “child” rows below the “parent” row. In a parent row, click on the “+” sign; it expands the child row with detailed information. At the same time, the parent sign toggles to “- “.

Once we click on “– “sign, then it will collapse child rows with parent sign “+”.

The requirements are,

Put a class of “parent” on each parent row (tr).
Give each parent row (tr) an attribute ”data-toggle=”toggle””.
Give each child row cover under <tbody> a class=hideTr.

Below is the sample of the table structure.

<table>
<tr data-toggle=”toggle”>
<td >
<p id=”Technology” >
<b>
<span class=”plusminusTechnology”>+</span>
<span lang=”EN-IN”>Technology </span>
</b>
</p>
</td>
<td ></td>
<td ></td>
</tr>
<tbody class=”hideTr”>
<tr >
<td “></td>
<td >
<img height=”28″ src=”clip_image001.png” v:shapes=”Picture_x0020_5″ width=”106″ />
</td>
<td
<span lang=”EN-IN”>4</span>
</td>
<td
</td>
</tr>
</tbody>
</table>

Script Code

<script src=”https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js”></script>  
<script type=”text/javascript”>
$(document).ready(function () {
debugger;
$(‘.hideTr’).slideUp(600);
$(‘[data-toggle=”toggle”]’).click(function () {
if ($(this).parents().next(“.hideTr”).is(‘:visible’)) {
$(this).parents().next(‘.hideTr’).slideUp(600);
$(“.plusminus” + $(this).children().children().attr(“id”)).text(‘+’);
$(this).css(‘background-color’, ‘white’);
}
else {
$(this).parents().next(‘.hideTr’).slideDown(600);
$(“.plusminus” + $(this).children().children().attr(“id”)).text(‘- ‘);
$(this).css(‘background-color’, ‘#c1eaff ‘);
}
});
});
</script>

Second option

A common UI which will have an HTML table of record rows, in which when we click on “Expand”, it shows a detailed breakdown of “child” rows below the “parent” row.

The requirements are:

Add a class of “parent” on each parent row (tr).
Give each parent row (tr) an id.
Give each child row a class of “child-ID” where ID is the id of the parent tr that it belongs to.

<table id=”detail_table” class=”detail”>
<thead>
<tr>
<th>ID</th>
<th colspan=”2″>Name</th>
<th>Total</th>
</tr>
</thead>
<tbody>
<tr class=”parent” id=”row123″ title=”Click to expand/collapse” style=”cursor: pointer;”>
<td>123</td>
<td colspan=”2″>Bill Gates</td>
<td>100</td>
</tr>
<tr class=”child-row123″ style=”display: table-row;”>
<td> </td>
<td>2018-01-02</td>
<td>A short description of Microsoft revenue </td>
<td>15</td>
</tr>
<tr class=”child-row123″ style=”display: table-row;”>
<td> </td>
<td>2018-02-03</td>
<td>Another New Project description</td>
<td>45</td>
</tr>
<tr class=”child-row123″ style=”display: table-row;”>
<td> </td>
<td>2010-03-04</td>
<td>More New Stuff</td>
<td>40</td>
</tr>
<tr class=”parent” id=”row456″ title=”Click to expand/collapse” style=”cursor: pointer;”>
<td>456</td>
<td colspan=”2″>Bill Brasky</td>
<td>50</td>
</tr>
<tr class=”child-row456″ style=”display: none;”>
<td> </td>
<td>2009-07-02</td>
<td>A short Two Describe a Third description</td>
<td>10</td>
</tr>
<tr class=”child-row456″ style=”display: none;”>
<td> </td>
<td>2008-02-03</td>
<td>Another New story description</td>
<td>20</td>
</tr>
<tr class=”child-row456″ style=”display: none;”>
<td> </td>
<td>2009-03-04</td>
<td>More story Stuff</td>
<td>20</td>
</tr>
<tr class=”parent” id=”row789″ title=”Click to expand/collapse” style=”cursor: pointer;”>
<td>789</td>
<td colspan=”2″>Phil Upspace</td>
<td>75</td>
</tr>
<tr class=”child-row789″ style=”display: none;”>
<td> </td>
<td>2008-01-02</td>
<td>A short New Games description</td>
<td>33</td>
</tr>
<tr class=”child-row789″ style=”display: none;”>
<td> </td>
<td>20011-04-03</td>
<td>Another Games description</td>
<td>22</td>
</tr>
<tr class=”child-row789″ style=”display: none;”>
<td> </td>
<td>20011-04-04</td>
<td>More Games Stuff</td>
<td>20</td>
</tr>
</tbody>
</table>

Script Code

<script src=”https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js”></script>  
<script type=”text/javascript”>
$(document).ready(function () {
$(‘tr.parent’)
.css(“cursor”, “pointer”)
.attr(“title”, “Click to expand/collapse”)
.click(function () {
$(this).siblings(‘.child-‘ + this.id).toggle();
});
$(‘tr[@class^=child-]’).hide().children(‘td’);
});
</script>

Remote Debugging Of SharePoint Custom Application In Visual Studio

Posted: October 31, 2020 in SharePoint2013

Introduction

In this article, we will explore how to remote debug a SharePoint custom application in Visual Studio (SharePoint Test sever to Dev Server).

Scenario

An application works completely fine in SharePoint Dev environment but fails to work in the test environment. Then, how do we find out the issue in the test environment and make the application work?

Pre-requisite

Verify whether GAC manage tool is installed or not. If it’s not, then install GAC Manager.

This problem can be resolved using the remote debugging method. The step-by-step procedure is given to resolve the issue.

Sharepoint Test Environment Remote Debugging Steps

Steps 1

Connect to Test Server ->Find Remote Debugger, right click and run as an Administrator.

Sharepoint Test Environment Remote Debuging

Steps 2

Pop up window for setting the unique TCP/IP Port Number will appear on screen,

If Remote debugger icon does not appear on the desktop then follow the below steps for remote debugger configuration.

Steps 3

Open Windows Explorer and navigate to the following directory – C:\Program Files\Microsoft Visual Studio 14.0\Common7\IDE\Remote Debugger.

Once you’re in the Remote Debugger directory, double-click on the appropriate directory name based on the processor of your web front-end server (i.e. x64 is most likely what you’ll choose if you’re working with SharePoint 2013).

Double click on the msvsmon file,

On pop up of the VS remote debugger window Go ->Tools ->permissions, add the username of the Dev server administrator account ->Click Apply ->Ok.

Steps 4

Run with Administrator open GAC Manager Tool- -> Click following Sharepoint Test Environment Remote Debuging Icon Add your custom solution DLL into GAC Manager -> reset IIS by opening a command prompt by typing “iisreset,

SharePoint Dev Environment Steps

These final steps of the process will now allow you to connect your instance of Visual Studio with the remote debugging monitor so that you will, at last, be able to step through the C# code of your SharePoint components.
On your workstation, open Visual Studio.
Open your SharePoint site’s code solution file.
Once your solution is loaded, open the appropriate .cs file you wish to debug and place your breakpoint(s).
Click Debug -> Attach to Process.
For Qualifier, update the textbox with the remote debugging server name that you captured in Test Environment Step 3 of the Activate the Visual Studio Remote Debugging Monitor section.
Select the w3wp.exe process that matches the ID that you recorded in Step 5 of Dev Environment to Obtain the Worker Process ID section.
Click the Attach button.
Refresh Test Environment SharePoint application then the debugger will be activated in SharePoint Dev Environment.

Add Quick Launch Link To SharePoint 2013 Site Using REST API

Posted: October 31, 2020 in SharePoint2013

Introduction

In this article, I have explored how to add links represented as headings in the Quick Launch area of the user interface using REST API. Here, we tried to add custom navigation node corresponding to the links in the Quick Launch area of the site using REST API using jQuery.

Prerequisites –REST API QuickLaunch EndPoint to use in Add_ins –

/_api/web/Navigation/QuickLaunch

Scenario

I have created the host site and have by default added multiple Quick Launch navigation nodes. Now, let’s say we want to add one Custom navigation nodes ‘’Notebook” in the Quick Launch (i.e., Left Navigation).

SharePoint

Objective

I have added one custom navigation node ‘’ Notebook” to the Quick Launch (i..e Left Navigation) on button click.

Use the procedure given below.

Step 1

Navigate to your SharePoint 2013 site.

Step 2

From this page, select Site Actions | Edit Page.

Edit the page, go to the “Insert” tab in the ribbon and click “Web Part” option. In the Web Parts picker area, go to the “Media and Content” category, select the Script Editor Web Part, and press the “Add” button.

Step 3

Once the Web Part is inserted into the page, you will see an “EDIT SNIPPET” link; click it. You can insert HTML and/or JavaScript, as shown below.

<script type=”text/javascript” src=”../…/SiteAssets/Script/jquery-1.10.2.js”></script>
<script type=”text/javascript”>
$(document).ready(function ($) {
$(“#createQuickLaunch”).click(function () { createQuickLaunch() });
});
//Create a Quicklaunch Navigation
function createQuickLaunch() {
var endPointUrl = _spPageContextInfo.webAbsoluteUrl + “/_api/web/navigation/QuickLaunch”;
var headers = {
“accept”: “application/json;odata=verbose”,
“content-Type”: “application/json;odata=verbose”,
“X-RequestDigest”: jQuery(“#__REQUESTDIGEST”).val()
}
var call = jQuery.ajax({
url: endPointUrl,
type: “POST”,
data: JSON.stringify({
“__metadata”: { type: “SP.NavigationNode” },
‘IsExternal’: true,
‘Title’: “Notebook”,
‘Url’: “http://www.testnotebook.com”  
}),
headers: headers
});
call.done(successHandler);
call.fail(failureHandler);
}
function successHandler(data, textStatus, jqXHR) {
SP.UI.Notify.addNotification(“Navigation created Successully”, false);
}
function failureHandler(errorMessage) {
alert(“Request Failed: unable to Navigation: ” + JSON.stringify(errorMessage));
}
</script>

Final out Put

Click ” Create Navigation” button.

SharePoint

How To Trigger SharePoint 2013 Designer Workflow On A List Item By Calling REST API Using jQuery

Posted: May 12, 2020 in SharePoint2013

Introduction

In SharePoint 2013 designer workflow, we uncheck the workflow triggering mechanism on a list item being created or updated. This is done in an effort to prevent the recursive calls to the workflow initiation.

However, even though it takes quite a few workflow Start options, it is still possible to start the workflow manually from within the calling workflow. The following Option does the trick: start workflow automatically when an item is Created/Changed in Workflow Designer internally (automatically)

Scenario

I have created a custom list named “TEST” on the host site and have added multiple items. Now, let’s say we want to “Trigger the Sharepoint 2013 list workflow” on any particular item and send an email to the user as per our need.

Sharepoint

Objective

I wanted to get the item ID of the list item so that I could use it in my HTML to fetch the Item ID of the list item and bind to the drop-down. Once we have selected any Item ID from the list of Item IDs from the drop-down, click on the “Trigger Workflow” button.

Use the procedure given below.

I have created a simple Sharepoint designer workflow for sending an email. Given below is the created mail template.

Sharepoint

In the following code, we fetch the “subscriptionId” in the code as per our Workflow

Step 1

Navigate to your SharePoint 2013 site.

Step 2

From this page, select Site Actions | Edit Page.

Edit the page, go to the “Insert” tab in the Ribbon and click “Web Part” option. In the Web Parts picker area, go to the “Media and Content” category, select the Script Editor Web Part, and press the “Add” button.

Step 3

Once the Web Part is inserted into the page, you will see an “EDIT SNIPPET” link; click it. You can insert HTML and/or JavaScript, as shown below.

<script type=“text/javascript” src=“../…/SiteAssets/Script/jquery-1.10.2.js”></script>
<script type=“text/javascript”>
$(document).ready(function ($) {
ItemIdDropDownBind();
$(“#StartWorkflow”).click(function () { StartWF() });
});
//StartWorkflow
function StartWF() {
$.ajax({
url: _spPageContextInfo.siteAbsoluteUrl + “/_api/SP.WorkflowServices.WorkflowInstanceService.Current/StartWorkflowOnListItemBySubscriptionId(subscriptionId=’BB20B816-2AEF-4299-B6BF-43910578BA8F’,itemId=’ “ + $(“#drpItem option:selected”).text() + “‘)”,
type: “POST”,
contentType: “application/json;odata=verbose”,
headers: {
“Accept”: “application/json;odata=verbose”,
“X-RequestDigest”: $(“#__REQUESTDIGEST”).val()
},
success: function (data) {
alert(‘Workflow Trigger Successfully’);
},
error: function (data) {
alert(“Error”);
}
});
}
function ItemIdDropDownBind() {
var url = _spPageContextInfo.webAbsoluteUrl + “/_api/web/lists/getbytitle(‘TEST’)/items?$orderby=ID asc&$top=5000”;
getListItems(url, function (data) {
var items = data.d.results;
var inputItemIDElement = ‘<select id=”drpItem” name=”options”><option value=””></option>’;
for (var i = 0; i < items.length; i++) {
var itemId = items[i].ID,
itemVal = items[i].ID;
inputItemIDElement += ‘<option value=”‘ + itemVal + ‘”selected>’ + itemId + ‘</option>’;
}
inputItemIDElement += ‘</select>’;
$(‘#ItemID’).append(inputItemIDElement);
}, function (data) {
alert(“An error occurred. Please try again.”);
});
}
function getListItems(siteurl, success, failure) {
$.ajax({
url: siteurl,
method: “GET”,
headers: { “Accept”: “application/json; odata=verbose” },
success: function (data) {
success(data);
},
error: function (data) {
failure(data);
}
});
}
</script>

Final out Put

Select the Item Id and click “Trigger workflow” button.

Sharepoint

Sharepoint
Trigger Workflow Email O/P

Some Useful JavaScript Methods, Variable And Objects In Sharepoint 2013

Posted: September 10, 2019 in SharePoint2013

Introduction

In my previous blog, I explored _spPageContextInfo variable properties. This time, I am exploring some SharePoint-provided useful methods and objects in JavaScript. Following are the methods and objects which I use frequently in JavaScript. All these are available Out-Of-The-Box and you don’t need to add any JavaScript library.

JSRequest (Object)
This is used for getting Query String Values. JSRequest class is a JavaScript object in SharePoint. Before using any of these properties, you should call JSRequest.EnsureSetup();

Ex: page URL is http://Siteur/ListName/EditForm.aspx?ID=9

To get a query string value, use the following code.

JSRequest.EnsureSetup();
var Id = JSRequest.QueryString[“ID”]; // Id= 8

Similarly, you can use this –

JSRequest.EnsureSetup();
var fileName = JSRequest.FileName; // current page name
var pathname = JSRequest.PathName; // server relative url

GetUrlKeyValue(parameter, noDecode, url) (Method)
These SharePoint utilities and functions are available on the client-side of SharePoint 2013 to get the value from the query string of the URL.

alert(GetUrlKeyValue(‘a’, false, ‘www.xyz.com?a=fi%20rst’));

The above statement will return the value ‘fi rst’. Here we are specifying our own URL.

alert(GetUrlKeyValue(‘S’, false));

The above statement will look for a query string variable ‘S’ in the browser URL and return the decoded value.

alert(GetUrlKeyValue(‘S’));

The above statement will look for a query string variable ‘S’ in the browser URL.

SetUrlKeyValue (parameterName, parameterValue, bEncode, url)
This SharePoint utility is opposite to GetUrlKeyValue. In GetUrlKeyValue function, we will get the value from the query string and in SetUrlKeyValue, we will be setting the value to the query string .

parameterName
The query string name to which we need to set the value.
parameterValue
The parameter value that needs to be set to the keyName.
bEncode
Whether the value needs to be encoded in the URL before setting the value.
url
Url to which the value needs to be set.
1. SetUrlKeyValue(‘EditPage’, ‘true’, false, window.location.href);
2. SetUrlKeyValue(‘EditPage’, ‘true’, false,http://www.google.com’);

ScriptUtility
This class is the home to six very useful helper methods and one helper field.
emptyString
This field returned an empty string in JavaScript “ ”

SP.ScriptUtility Methods

isNullOrEmptyString – Checks if the specified text is null, an empty string or undefined
isNullOrUndefined – Checks if the specified object is null or undefined.
isUndefined – Checks if the specified object is undefined.
truncateToInt – Returns largest integer value that is less than or equal to the specified number if the number is greater than 0 else returns the smallest integer value that is greater than or equal to the number.
ScriptUtility : It merely acts as a placeholder for the class name SP.ScriptUtility to hold the Above methods.

escapeProperly(str) (Method)

This function returns escapeProperly function returns the encoded value for provided string.

var s = escapeProperly(“hello world!!”); //s = “hello%20world%21%21”

SP.Guid

The function SP.Guid.newGuid().toString() returns new GUID at runtime.

var guid=SP.Guid.newGuid().toString();//guid =”260868ac-2c0c-4494-a40e-22b00aaa0312″

unescapeProperly(str) (Method)

This function returns unescapeProperly function that returns decoded string for provided encoded string.

var Outstr=unescapeProperly(“this%20is%20a%20test”)//Outstr=”this is a test”

escapeProperly(str) (Method)

This function returns escapeProperly function returns the encoded value for provided string.

Location
init.js
Parameters
str
1. var urlEncodedValue = escapeProperly(“My Value”); // Returns “My%20Value”.

TrimSpaces(str)

This function can be to trim spaces on a string. A string that will be trimmed. Return value he trimmed string.

var trimmed = TrimSpaces(” string with spaces “); // Returns “string with spaces”.

TrimWhiteSpaces(str)

This method trims the white spaces of a string and It also removes spaces created spaces, tabs and linebreaks (\t \n \r \f). A string that will be trimmed.Return valueThe trimmed string.

var trimmed = TrimWhiteSpaces(“\t\tstring with spaces\n”); // Returns “string with spaces”.

variable :L_Menu_BaseUrl

This variable contains the base URL of the current site or subsite.

Ex. document.location = L_Menu_BaseUrl + ‘Lists/Tasks/AllItems.aspx’;
variable: L_Menu_LCID

This variable contains the LCID setting of the current site.
Variable: L_Menu_SiteTheme

This variable contains the theme name of the current site.
Lots of this JavaScript Function is already written for you in SharePoint’s “Init.js“and “core.js” file follow the below tables,

Init.js (Function)

ULSTrim(str)
ULSEncodeXML(str)
PageUrlValidation(url)j GetCurrentEltStyle(element, cssStyle)
IsCheckBoxListSelected(checkboxlist)
STSHtmlEncode(str)
DeleteCookie(sName)
GetCookie(sName)
navigateMailToLink(strBody)
navigateMailToLinkWithMessage(strTo, strBody)
makeAbsUrl(strUrl)
HideMenuControl(menuControlId)
displayPNGImage(id,src,width,height,alt)
GetUrlKeyValue(keyName, bNoDecode, url)
GoToPage(url)
TrimSpaces( str )
TrimWhiteSpaces( str )
FormatDate(sDate, sTime, eDate, eTime)
GetElementByClassName(elem, classname)
WpClick(evt)
GetViewportHeight()
GetViewportWidth()
RemoveQueryParameterFromUrl(stURL, stParameterName)
HasValidUrlPrefix(url)
AbsLeft(obj)
AbsTop(obj)
ExecuteOrDelayUntilScriptLoaded(func, depScriptFileName)
ShowPopupDialog(dlgUrl)

core.js(Function)

NewItem(url)
EditItem(url)
RefreshPageTo(evt, url, bForceSubmit)
PopMenuFromChevron(e)
RefreshPage(dialogResult)
OpenPopUpPage(url, callback, width, height)
OnIframeLoad()
RemoveUrlKeyValue(keyName, url)
RemoveParametersFromUrl(url)
_GoToPageRelative(url)
ShowInPopUI(evt, currentCtx, strUrl)
OpenPopUpPageWithTitle(url, callback, width, height,title)
AddSourceToUrl(url)
ConvertMultiColumnValueToString(subColumnValues,delimiter,bAddLeadingTailingDelimiter)
Log(str)
CountTotalItems(ctxCur)
CountSelectedItems(ctxCur)
_addNotificationInternal(span, strHtml, bSticky, tooltip, onclickHandler, bNoAnimate)
removeNotification(id, bNoAnimate)
SetCookie(name, value, path)

Show SharePoint List Item Level Attachments Using REST API And jQuery

Posted: September 10, 2019 in SharePoint2013

Introduction

In this article, we will explore in Sharepoint 2013, how to show the Sharepoint list item level attachments using REST API and jQuery. In the previous article, I explained about adding multiple attachments to list item using HTML and jQuery. Now, let’s use some REST API to pull these attachments and display them in the list.

For retrieving attachments, I am using REST API. The URL for all attachment collections can be built like below.

{Site URL}/_api/web/lists/getbytitle([List Title])/items([item ID])/AttachmentFiles

Scenario

I have created a custom list on the host site named “Attachment”. Add multiple items with attachments and let’s say that we want to show the item level attachments in the item selection.

SharePoint

I have an item (Item ID: 1) that has the following attachments
SharePoint

Objective

I wanted to get the URLs of the list item attachments so that I could use it in my HTML and to fetch the Item ID of the list item and bind to the drop-down. Once we have selected any Item ID from the list of Item IDs from the drop-down, the attachments of the respective item are shown. An “on change” event is used to fetch and we show the related attachments.

Use the procedure given below.

Step 1

Navigate to your SharePoint 2013 site.

Step 2

From this page, select Site Actions | Edit Page.

Edit the page, go to the Insert tab in the Ribbon and click Web Part option. In Web Parts picker area, go to the “Media and Content” category, select the Script Editor Web Part and press the “Add” button.

Step 3

Once the Web Part is inserted into the page, you will see an “EDIT SNIPPET” link; click it. You can insert HTML and/or JavaScript, as shown below.

“text/javascript” src=“../../SiteAssets/Script/jquery-1.9.1.min.js”>
“text/javascript”>
$(document).ready(function ($) {
var url = _spPageContextInfo.webAbsoluteUrl + “/_api/web/lists/getbytitle(‘Attachments’)/items?$select=Id”;
getListItems(url, function (data) {
var items = data.d.results;
var SelectElement = ‘Select’;
// Add all the Item Id in Dropdown
for (var i = 0; i
var itemId = items[i].Id;
SelectElement += ‘ + itemId + ‘”selected>’ + itemId + ”;
}
SelectElement += ”;
$(‘#ItemID’).append(SelectElement);
// assign the change event
$(‘#drpListItem’).on(‘change’, function () {
if ($(this).val() != “”) {
var Requestorurl = _spPageContextInfo.webAbsoluteUrl + “/_api/web/lists/getbytitle(‘Attachments’)/items(“ + $(this).val() + “)/AttachmentFiles”;
getListItems(Requestorurl, function (data) {
var results = data.d.results;
var htmlStr = “”;
if (data.d.results.length > 0) {
$.each(data.d.results, function () {
if (htmlStr === “”) {
htmlStr = “
+ this.ServerRelativeUrl + “‘>” + this.FileName + “
“;
}
else {
htmlStr = htmlStr + “
+ this.ServerRelativeUrl + “‘>” + this.FileName + “
“;
}
});
}
else { htmlStr = “There are no attachments to show in this item.“; }
$(‘#attachmentsContainer’).html(htmlStr);
});
}
});
}, function (data) {
console.log(“An error occurred. Please try again.”);
});
});
function getListItems(siteurl, success, failure) {
$.ajax({
url: siteurl,
method: “GET”,
headers: { “Accept”: “application/json; odata=verbose” },
success: function (data) {
success(data);
},
error: function (data) {
failure(data);
}
});
}

Final Output

List Item with attachments.
List item without attachments.

Different Operation On SharePoint People Picker

Posted: February 7, 2019 in SharePoint2013

Introduction

In this article I have explored different operations on Sharepoint people picker like:

Hide , show and set as Read-only people picker
Get and set people picker item
Get User Properties & basic property
Ensure the user

A lot of people come across the same requirements in Sharepoint people picker.

I developed this POC, which often proves helpful to deal with investigating user properties. Basic property gets associated with People Picker control. Also I explore hide and show people picker control from Sharepoint Default New and Edit list form.

Hide, show and set as read-only people picker

Here, using jQuery, we handle the hide, show, and set as read only people control without using SPUtitlity.

Hide and Show People Picker: In Sharepoint list, default New or Edit form on the basis of condition. Set people picker control as hide and show using jQuery.

SharePoint People Picker
Script code

$(“div[title=’Column Name’]”).hide();
$(“div[title= ‘Account Holder Name’]”).hide();

SharePoint People Picker
Script code

$(“div[title= ‘Account Holder Name’]”).show();

SharePoint People Picker
Read-only People picker

In Sharepoint list, default New or Edit form on the basis of condition; set people picker control as read-only using jQuery.

SharePoint People Picker
Script

var data = $(“Div [title=’Account Holder Name’] > input”).val ();
var parsed = JSON.parse(data);
var UserDisplayName = parsed[0].DisplayText;
$(“div[title=’Account Holder Name’]”).hide();
$(“div[title=’Account Holder Name’]”).after(UserDisplayName);

Get and set people picker item

Set People Picker Item

Set run time people picker value using jQuery In Sharepoint, list default New/Edit form on the basis of current login username.

SharePoint People Picker
Script

$(document).ready(function(){
var userid = _spPageContextInfo.userId;
var requestUri = _spPageContextInfo.webAbsoluteUrl + “/_api/web/getuserbyid(“ + userid + “)”;
var requestHeaders = { “accept”: “application/json;odata=verbose” };
$.ajax({
url: requestUri,
contentType: “application/json;odata=verbose”,
headers: requestHeaders,
success: onSuccess,
error: onError
});
function onSuccess(data, request) {
var Logg = data.d;
//var loginName = Logg.LoginName; //get login name
var loginName = data.d.LoginName.split(‘|’)[1];
ExecuteOrDelayUntilScriptLoaded(function () {
setTimeout(function () {
SetAndResolvePeoplePicker(“Account Holder Name”, loginName);
}, 2000);
}, ‘clientpeoplepicker.js’);
}
function onError(error) {
alert(“error”);
}
});
function SetAndResolvePeoplePicker(fieldName, userAccountName) {
// alert(userAccountName);
var _PeoplePicker = $(“div[title='” + fieldName + “‘]”);
var _PeoplePickerTopId = _PeoplePicker.attr(‘id’);
var _PeoplePickerEditer = $(“input[title='” + fieldName + “‘]”);
userAccountName.split(“;#”).forEach(function (part) {
if (part !== “” && part !== null) {
_PeoplePickerEditer.val(part);
var _PeoplePickerOject = SPClientPeoplePicker.SPClientPeoplePickerDict[_PeoplePickerTopId];
_PeoplePickerOject.AddUnresolvedUserFromEditor(true);
}
});
}

SharePoint People Picker
Get People Picker Item

Get run time people picker value using jQuery In Sharepoint, list default New/Edit form on the basis of current login username.

SharePoint People Picker

Script

var data = $(“Div[title=’Account Holder Name’] > input”).val();
var parsed = JSON.parse(data);
var AccountName = parsed[0].Key;
alert(AccountName);

Get User Properties & basic property

Without using REST API, dynamically get People picker user, all types of User Properties & basic properties using jQuery

SharePoint People Picker

Script

var data = $(“Div[title=’Account Holder Name’] > input”).val();
var parsed = JSON.parse(data);
alert(‘Account Name:-‘+ parsed[0].Key +‘\nDisplay Name:-‘+parsed[0].DisplayText +‘\nUser Name:-‘+ parsed[0].Description +‘\n —–User Properties——-\n’+parsed[0].EntityData.Title +‘\n’+parsed[0].EntityData.Department+‘\n’+parsed[0].EntityData.SIPAddress+‘\n’);

SharePoint People Picker

Ø Ensure the user: In People Control we can ensure user is exist or not in Sharepoint list New and Edit Form

Script

var data = $(“Div[title=’Account Holder Name’] > input”).val();
var parsed = JSON.parse(data);
var isResolved = parsed[0].IsResolved;
if (isResolved == true) {
return true;
} else {
$(“Div[title=’Account Holder Name’]”).after(“User does not exist”);
return false;
}

Remove U+200B (Zero-Width Space) In RichTextHTML Field SharePoint

Posted: February 7, 2019 in SharePoint2013

Introduction

In this article, we will explore how to resolve the error that arrives while implementing the validation to enhanced/rich text box of SharePoint 2013 using jQuery. We will call this error the “Zero-width space” issue.

I observed that the mandatory enhanced/rich text box of SharePoint 2013 doesn’t throw an error when we cut the content from it from the edit/new form and it allows us to save the form without any content in the rich text box. The article describes the steps to remove this error.

Sharepoint

The Rich text editor in Sharepoint 2013 inserts “zero width spacing” characters when editing HTML. Unfortunately, these are not visible to the normal user and so is difficult to remove, so much for WYSIWYG! I analyzed that these are visible in Chrome browser.

Solution

Need to avoid the div tags and get data alone from multiline textbox field using the following steps.

Step 1

Navigate to your SharePoint 2013 site.

Step 2

From this page, select the Site Actions | Edit Page.

Go to the “Insert” tab in the ribbon and click the “Web Part” option. In the “Web Parts” picker area, go to the “Media and Content” category, select the “Script Editor” Web Part, and press the “Add button”.

Step 3

Once the Web Part is inserted into the page, you will see an “EDIT SNIPPET” link; click it. You can insert the HTML and/or JavaScript as in the following,

“text/javascript” src=“/Script/jquery-1.10.2.js”>
“text/javascript”>
var oLoader;
var attcount = 0;
var arraycount = 0;
$(document).ready(function() {
$(‘h3.ms-standardheader:contains(“Employee Account Number”)’).append(‘ *‘);
});
function PreSaveAction() {
var EmpAcctNum = $(“td.ms-formlabel h3.ms-standardheader nobr:contains(‘Employee Account Number’)”).parent().parent().parent().find(“div.ms-inputBox div.ms-rtestate-write”).text();
var EmpAcctNum_validatiomsg = “You can’t leave this blank.
“;
EmpAcctNum = EmpAcctNum.replace(/[\u200B-\u200D\uFEFF]/g, ”);
if (IMPONuM.trim() == “”) {
$(“#EmpAcctNum”).remove();
$(“td.ms-formlabel h3.ms-standardheader nobr:contains(‘Employee Account Number’)”).parent().parent().parent().find(“div.ms-inputBox div.ms-rtestate-write”).closest(“span”).after(EmpAcctNum_validatiomsg);
return false;
} else {
$(“#EmpAcctNum”).remove();
return true;
}
}

Output

Before,

Sharepoint
After,

How To Debug Custom Applications In SharePoint 2013

Posted: February 7, 2019 in SharePoint2013

Introduction

This article is for beginner level Sharepoint developers and it explores how to debug SharePoint custom applications along with the standard ways to debug.

Debug a Microsoft SharePoint Custom Web part with Visual Studio

SharePoint custom visual web part is executed and debugged by the worker process which is a Windows process (w3wp.exe).

Here are the steps to debug a web part in SharePoint.

Step 1

Open the project and set appropriate breakpoints.

Step 2

Create a Web Part page on the default SharePoint site.

Step 3

Add the Web Part to the page.

Step 4

Attach the debugger to the W3wp
In the Debug menu in Visual Studio .NET, click “Processes”.
Verify that the “Show system processes” check box is selected.
Verify that the “Show processes in all sessions” check box is selected.
Under “Available Processes”, click exe in the Process list, and then click “Attach”.
Under “Choose the program types that you want to debug”, select Common Language Runtime.
Now, click OK and then “Close”.
Follow the below steps for finding the application related Work process,
Open CMD -> cd C:\Windows\System32\inetsrv-> appcmd list wp

Debug a Microsoft SharePoint Timer Job with Visual Studio

SharePoint timer jobs are tasks executed on a scheduled basis by the Windows SharePoint Services timer service (owstimer.exe). They are analogous to scheduled tasks,

First, deploy your solution containing your timer job to SharePoint. From Visual Studio, click “Build” and then “Deploy Solution”.
Open Windows Services. ( Click the “Start” button and type Services; or alternatively, this can be accessed from Control Panel > System and Security > Administrative Tools).
Select the service namedSharePoint Timer Services. This ensures that the latest DLL is loaded for your timer job.

From Visual Studio, attach the debugger to the process named OWSTIMER.EXE. To do so, select “Debug and Attach to Process”. You may need to tick the check box “Show processes from all users” to find OWSTIMER.EXE.

Packaging And Deploying In SharePoint 2013 Designer Workflow

Posted: February 7, 2019 in SharePoint2013

Introduction

SharePoint Designer 2013 provides the capability to save a workflow as a template. Saving a workflow as a template is also known as packaging the workflow. This capability is absent in Sharepoint 2010 List Workflow. In this article, we will explore all the steps regarding Packaging, Deploying and Workflow registration. In Sharepoint 2010/2013, not all workflow types can be saved as template. The following table shows the workflow types that can be saved as template.

Workflow type	SharePoint 2010 Workflow platform	SharePoint 2013 Workflow platform
List Workflow	No	Yes
Site Workflow	No	Yes
Reusable Workflow	Yes	Yes

Scenario

You’ve created a SP Designer Workflow in one (test) environment and want to deploy onto another (Production) environment. Follow the below steps to move the workflow to other (production) environment site:

Create Solution – Package a workflow by using SharePoint Designer 2013

In order to use this workflow on another Server, you have to save this workflow as a SharePoint Solution package (.wsp file), and then deploy it as a solution on the other server (Production).

To package a workflow, follow these steps:

Open site in SharePoint Designer 2013.
On the “Workflow Settings” tab in the ribbon, click the “Save as Template” button in the “Manage” section, as shown in the figure.
The .wsp file is now located in the Site Asset library in the Site Collection on your Test Server.
Go to Site Content => Site Assets and you will find Exception Approval .wsp file.
Download a copy of this file to any directory on your computer.

Deploy a SharePoint solution package

Open Internet Explorer and navigate to the site collection you want to deploy the workflow in.
Copy the .wsp file from your computer to a local directory on your Production Server.
Click “Site Actions” and select “Site Settings”.
In the Web Design Galleries section, click Solutions.
Click the “Upload Solution” button to upload the .wsp solution, as shown in the figure.

Figure – Upload Solution button
Activate the solution by clicking “Activate”.

Figure – Activate Solution dialog and button

After a workflow solution has been activated for a site collection, just follow this procedure.

Activate the workflow feature

Open “Site Settings” on the site where you wish to activate the workflow feature.
In the “Site Actions” group, click “Manage site features”.
Click “Activate” next to the workflow feature, as shown in the figure.

Figure – Activate workflow feature for site

Note

In workflow, if you are using an app, then you must Register workflow App permission after deployment.

	sharepointapp09 on Use Of PreSaveAction Function…
	Michael Williams on Use Of PreSaveAction Function…
	Marnie Benje on SharePoint 2010: JQuery Autoco…
	Dwain Gisler on Retrieve List Item and Dynamic…
	bhavesh on Expand/Collapse Table Rows Wit…

Sharepoint Rocks

Recent Posts

Recent Comments

Archives

Categories

Meta

Expand/Collapse Table Rows With jQuery

First Option for expanding/collapsing HTML table row

Second option

Remote Debugging Of SharePoint Custom Application In Visual Studio

Add Quick Launch Link To SharePoint 2013 Site Using REST API

How To Trigger SharePoint 2013 Designer Workflow On A List Item By Calling REST API Using jQuery

Some Useful JavaScript Methods, Variable And Objects In Sharepoint 2013

Show SharePoint List Item Level Attachments Using REST API And jQuery

Different Operation On SharePoint People Picker

Remove U+200B (Zero-Width Space) In RichTextHTML Field SharePoint

How To Debug Custom Applications In SharePoint 2013

Packaging And Deploying In SharePoint 2013 Designer Workflow