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 »