JavaScript Invalid Date or NaN in Internet Explorer - Solved

Recently, I faced an issue with Internet Explorer while I was working with Date() function of JavaScript. This issue occurred when I was passing string which has the date to the JavaScript Date() function and wanted to display it on the page. My code was this:   <script type="text/javascript">        var dateValue = "2016-01-06 00:43:06";        var date = new Date(dateValue);       ...

Read More »

Hide Save Button From Ribbon In SharePoint

Introduction Many times in SharePoint we want to perform different things which are not possible by using the available features which SharePoint provides Out of the Box. Hiding Save button in the SharePoint list forms ribbon is one of them. Usually, when we create/edit a new item in SharePoint lists, we have two Save buttons available. One is in top ribbon of the page and another one at the end of the form controls. Let's suppose, we have a scenario where we don't want two save buttons...

Read More »

CAML Query Builder for SharePoint Online

Introduction Folks, you might have seen lots of CAML Query Builder tools available for SharePoint On-premise but when it comes to SharePoint Online, we don't find much of the tools available.  Even if some tools are available, there are lots of problem in installing or configuring them and to make them work especially for SharePoint Online. Here, I will be sharing an information with you all on from where we can download the SharePoint CAML Query Builder tool for SharePoint Online...

Read More »

Check If An Item Exists In SharePoint List

How to check if an item exists in SharePoint list using SPServices? Pre-requisites: JQuery library - To download or to know more info on JQuery, please check here - https://jquery.com SPService library - To download or to know more info on SPServices, please check here - https://spservices.codeplex.com Basic knowledge of CAML query - To know more info on CAML, please check here - https://msdn.microsoft.com/en-us/library/office/ms426449.aspx Solution: ...

Read More »

Cannot connect to the server at this time. Your table cannot be published. - SOLVED

Problem: While importing data from excel file to SharePoint, user may get below error. Solution: This is a issue with permissions a user is having.  For e.g. if user is having "Contribute" access permission then with “Contribute” access permission level, we don’t have an access to create a list in a site. When we import from excel to SharePoint, SharePoint will create a list and as we do not have a permission to create a list, that’s why user may get this error. Solution...

Read More »

How to display Previous and Next buttons or icons in JQuery Datepicker

Folks, You must have noticed sometimes while using JQuery datepicker control (which comes from jquery-ui.css file) we get the datepicker control but it doesn't display "Previous" and "Next" buttons or icons as shown below. The fix is to apply a CSS and display them by using below code. <style type="text/css">         .ui-datepicker .ui-datepicker-prev span, .ui-datepicker .ui-datepicker-next span {            ...

Read More »

How to get QueryString from URL using JQuery

QueryString using JQuery There are lots of ways to get query-string from the web URL by using jQuery but this is the best way I feel to retrieve one or more than one query-strings parameters from the URL. How to do it? Let's suppose your URL is http://YourUrl.aspx. It has 2 query-string parameters i.e. "itemid" and "status". The parameter "itemid" has value as "1" and parameter "status" has value as "Approve". So, now your URL will be http://YourUrl.aspx?itemid=1&status=Approve. In...

Read More »

How to order fields in SharePoint custom list's NewForm.aspx page

Ordering fields in SharePoint custom list’s NewForm.aspx page We have seen that lots of time we need to change the order in which some fields appear on the new list item form (i.e. NewForm.aspx) for any of the SharePoint custom lists. Regardless of the ordering in the view you have selected or created, the fields always seem to appear in the order they were created while creating a custom list on the new item form. So question comes, how to reorder them? Well, one way is to create altogether...

Read More »

How to redirect from one page to another in SharePoint Sandbox solutions (especially when they are deployed to SharePoint Online)

How to redirect from one page to another in SharePoint Sandbox solutions (especially when they are deployed to SharePoint Online)? Answer - There are lots of ways to achieve this but the following one works almost everywhere for the sandbox solutions. On a button click event (or accordingly) of your ".cs" file, just add following code: string pageURL = "www.yourpageurl.com";var jscript = "<script type='text/javascript' language='javascript'>window.location='" + pageURL +...

Read More »

Change 'Title' Column Display Name Using List Definition In SharePoint

Question: How to change "Title" column display name in default view of a list when creating list by list definition using Visual Studio in SharePoint? Answer: In Schema.xml file of your list definition project, search for "Fields" tag (i.e. <Fields>) and just before the closing tag of this "Fields" tag (i.e. </Fields> ), put below line of code (also see attached image): <Field ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Type="Text" Name="LinkTitle" DisplayName="First...

Read More »

Cannot Connect To The SharePoint Site

Cannot Connect To The SharePoint Site While creating a SharePoint solution in Visual Studio, if you get an error shown in a screenshot below when you validate your SharePoint site URL, just provide user with a "DB_Owner" access to the "WSS_Content", "WSS_Logging" and "SharePoint_Config" database. This will resolve the issue. ...

Read More »