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 »

How to change a Title of a wiki page in SharePoint 2013 without affecting its page name and page URL

How to change a Title of a wiki page in SharePoint 2013 without affecting its page name and page URL Please also see my new post on - Easy Way To Change Wiki Page Title In SharePoint 2013 . In a SharePoint wiki page, if we would like to change the “Title” of a page, we would have to change the “Page Name” itself. This becomes very irritating because if we want our page title to be named as for example “My Page Title”, this will also rename the page name. Questions comes how...

Read More »

Could not find this item in Windows 7

Recently, I was trying to delete a file in my laptop (has Windows 7) which threw an error as "Could not find this item" and was not deleting that file at all. After searching for sometime, I finally found a solution which helped me in deleting the file. Here is the solution: 1) Open a Command Prompt. 2) Browse to the folder containing the buggy file. 3) Type 'dir /x' to obtain the 8.3 formatted filename. 4) Delete the file using the 8.3 filename, e.g. 'del 0WELCO~1' (as shown below) Hope...

Read More »

Open CSV file instead of saving in SharePoint 2013

Usually when we save any CSV file in SharePoint document library and we open it, the browser actually prompts to "Save" the file first and then gives "Open" file option. How to make some settings so that browser allows CSV files to get "Open" instantly without saving them? Here is the solution - In your SharePoint 2013 server, make the settings in “IIS Mime Types” and in “DOCICON” file to open the CSV files from the browser instead of saving them.Steps to follow are:a.      ...

Read More »

Implementing Autocomplete Textbox in SharePoint

Implementing Autocomplete TextBox in SharePoint In my recent project activity, I got a requirement to fill the textbox with autocomplete functionality. After some research and struggle, I was able to achieve it. The best thing about the solution I created is, it is cross browser compatible. I have tested it in Chrome and Internet Explorer. What is autocomplete? Autocomplete means when user starts typing the characters in a textbox, just below the textbox, user sees the suggestions. The...

Read More »