Character Count for Multi-line Text box in SharePoint List Forms

While working with SharePoint, you might have come across a scenarios where you need to count the character for Multi-line text-box in SharePoint list form. In this post I am going to implement Character Counter for Multi-line Text box using JQuery.

To outline the solution please follow the below steps –

Step 1 : Open your List new/edit form using SP Designer.

Step 2: Add tag under your multi line text filed description in the New form.

Step 3: Add the below code in your New form. and download Jquery latest file.

Step 4: Save the form and refresh your page.

Thank you. 🙂

Quick Search in SharePoint List Using JQuery

In this post I am going to implement a quick search in SharePoint list using JQuery that allows you to search records in a list. It is useful in a situation where you don’t have SharePoint Search setup and just need a simple way of performing search operations in a SharePoint List.

To outline the solution please follow the below steps –

• Download the latest JQuery file from Here
• Create a Custom SharePoint list in which you would like to implement the search
• Open the SharePoint Designer
• Go to All Files-> Lists->Select the name of the list we just created
• Paste the JQuery file (jquery-min.js) we just downloaded
• Create a new JavaScript File-> Rename the file as “QuickSearch.js”
• Open “AllItem.aspx” view and add the reference of both the JQuery file
  

  <script type=”text/javascript” src=” QuickSearch.js”>

  <script type=”text/javascript” src=”jquery-min.js”>

• Now Edit the “QuickSearch.js” file, type below code and Save the file

$(document).ready(function(){

$(“input.search”).change(function() {

     var txt = $(“input.search”).val();

     if (txt) {

              $(“#WebPartWPQ1”).find(“tr.ms-itmhover:not(:Contains(“+txt+”))”).hide();

               $(“#WebPartWPQ1”).find(“tr.ms-itmhover:Contains(“+txt+”)”).show();

                   } else {

                    $(“#WebPartWPQ1”).find(“tr.ms-itmhover”).show();

                  }

           }).keyup(function(){$(this).change();

     });

});

<div style=”padding: 5px; border: 1px solid #cccccc; width: 60%; margin: 10px auto 0pt; background: none repeat scroll 0% 0% #efefef; display: block;”>

<h3 style=”text-align: center;”>TYPE HERE : <input class=”search” style=”padding: 10px;” type=”text”/>

Explanation : We would like to start our function anytime the search input text is changed. Once it’s changed, it sets the value of a variable we have called “txt”.

Here we have an IF statement that just checks if there is indeed something in the search box, ELSE everything goes back to normal. If there is something inside the search input box, we are going to do two things. First, we’ll find any row that does NOT contain the string, and we’ll hide that row. Then we’ll find any row that DOES contain that string, and we’ll show that row. Finally, we chain a “keyup” function to the change function so that as we type everything is happening all together.

And last but not least, we created a simple search input box with a class of “search”.

Now open the SharePoint List All Item view in internet explorer and If you have done everything correctly then it will filter the items on the basis of your inputs.

PS : You’ll have to change the target WebPart ID it’s searching in and replace it with your current Web Part ID and its row class.

I hope you find this post useful.

Add an Attachment Field in SharePoint 2013 List Form

There are many instances where your customer would like to have Attach file option in the form itself instead of OOB option available in ribbon.Below I will show you how to have the “Browse” and “Upload” features directly on the form.

Open up SharePoint Designer 2013 and navigate to your list. Then click on the ASPX file you would like to edit under the “Forms” section.

In the code view of the form, place the below code to insert the Attachment Field
<tr>
<td rowspan=”2″ width=”200px” valign=”top” height=”25px”>
<b>Upload Files: </b> </td>
<td valign=”bottom” height=”25″ id=”attachmentsOnClient”>
<span dir=”ltr”>
<input type=”file” name=”fileupload0″ id=”onetidIOFile”
size=”60″ title=”Name”></input>
</span>
</td></tr>
<tr>
<td >
<input id=”attachOKbutton” type=”BUTTON” onclick=’OkAttach()’
value=”Upload” />
<span id=”idSpace”></span></td></tr>

Now you can see the browse button to upload the files into SharePoint list item.

Thanks. !! 🙂

Promoted Results in SharePoint 2013/Office 365

In this post I will write about how to create promoted results in SP 2013/Office 365. In SharePoint 2010 we had best bets to promote a result to the top of the search result list by using keywords. this was the great way to highlight a specific item in the result list. Best bets in Share Point 2010 is changed to promoted results in SharePoint 2013/Office 365.

To create Promoted Results, First open SharePoint Admin Center, click on Search from the left navigation and then click on “Manage Query Rules” link

In Manage Query Rules window, select Local SharePoint Result from the drop down of context and click on New Query Rule

On the Add New Query Rule page, Enter the Rule name and on the Context section select “Query Matched Keyword Exactly, enter keywords in the text box separated by semicolon. For e.g. Kavita;Mishra

Click on the “Add Promoted Results” link under Actions section and enter Title,  URL and description and then hit Save button

After completion of above details, click “Save” to save the Query Rule.

Now go to the search center. Type the word “Vision” or  “Policies”. The Company.docx would be displayed on top of the results with a tick mark

:):)

Create a Tabbed View in SharePoint 2013 using JQuery

While working with SharePoint, you might have come across a scenarios where you need to use the Tabbed View. In this post, I will share how to create a tabbed view for Multiple List Views in SharePoint 2013 (assuming that you have some SharePoint background) –

Step 1 : Create a Document Library (TabFiles) to store the required Jquery files

2. Upload below mention  js/css files in the Document Library (You can download these files from Here ).

• jquery-ui.min.js
• jquery-1.11.3.min.js
• jquery-ui.min.css

 
 

 

 

3. Now create the Custom list (Employee Details) to implement the Tabbed view –

4. Add some columns (Employee ID, Employee Name, Designation and Address) and then items in the list –

5. Create the first list view as “Vice President” –

6. Filter the View on the basis of Designation as “Vice President” –

7. Now create three more views (for Manager, Team Lead and Software Engineer) designation same as we just created for “Vice President” (Change the name of the view and filter value to Manager/Team Lead/Software Engineer).

8. After Creating all the four views, Open site in SharePoint Designer.

9. Open “Employee Details” Custom list AllItem.aspx page in Advanced mode-

10. Add the reference of js and css file (Which we have already uploaded in the “TabFiles” Document Library) –

11. Add four Div Section (Vice President/Manager/Team Lead/ Software Engineer) for List Views

12. Open the List view file (VicePresident.aspx) in SharePoint Designer which we have just created and Cut the “WebpartZone” section and Paste it under “VP” Div section on AllItem.aspx page.

13. Change the WebpartZone ID to Unique name on the page-


14. Follow the same for remaining three views Manager/Team Lead/Software Engineer –

• Cut The WebPartZone code from List View Page (Manager.aspx/ TeamLead.aspx/  SoftwareEngineer.aspx)
• Paste it under each Div Section on AllItem.aspx page
• Change the WebPartZone ID to Unique Name and save all the pages

15. Now open the Employee Details List in internet explorer and you will see the Employee Details List AllItem View has Converted into Tabbed view 🙂

I hope you liked it, Thanks for reading the blog 🙂

Create an App Catalog in SharePoint 2013 online

In this post, I’ll describe about creating an App catalog in SharePoint 2013 online, before diving into the details, I would like to give you a brief introduction about App Catalog.

The App Catalog is a special site collection on a web application that holds the apps, each web application can have only one App Catalog site collection whereas there can be multiple App Catalogs in a farm.

You can create the App Catalog site collection from SharePoint Central Administration or from Admin site in Office 365. I am using Office 365 for this example but the steps would be almost same.

1. Go to the Admin site in the Office 365 and Click on “SharePoint” link under Admin section

2. Click on “Apps” at left navigation

3. Select Create a new catalog site and then click on Ok.

4. Enter the details of the new app catalog site and then click on “OK”

5. An App Catalog site collection is created successfully.

By default the following document libraries will be available in the App Catalog site

• Apps for SharePoint : A library where Apps that can be use in SharePoint stays
• Apps for Office : This library is use to store the apps for Office
• App Requests : Users who do not have access to add an App, can add a new App Request for Admins to get the permission for the app. 

I hope you find this blog helpful 🙂

Microsoft pushed SharePoint 2016 release in Q2 2016

For those of you who have been waiting for the release of SharePoint 2016, the wait has just became a little longer, Microsoft has delayed the release of SharePoint server 2016 to second calendar quarter of 2016 (Q2 2016). This may be the first time Microsoft has pushed SharePoint release. But on April 16 announcement made by Seth Patton, senior director of product management for the SharePoint team. He confirmed that SharePoint Server 2016 will be available in Q2-2016 instead of 2015 and the first public beta version of SharePoint Server 2016 will be available in fourth calendar quarter of 2015 (Q4 2015).

SharePoint Server 2016 will deliver enhancements and new capabilities in three major areas:

• Improved user experiences
• Cloud-inspired infrastructure
• Compliance and reporting

Please check the below URL for the whole article

https://blogs.office.com/2015/04/16/sharepoint-server-2016-update/

If you would like to participate in beta testing, you can enroll here

http://prereleaseprograms-public.sharepoint.com/Pages/BusinessProfile.aspx

Change Master Page Layout (from Seattle.master to Oslo.master) in SharePoint 2013

In this post I am going to cover “How to change Master Page Layout (from Seattle.master to Oslo.master) in SharePoint 2013.

Go to Site Settings, click on “Change the Look” and then select the theme.

Now you can see “Site Layout” option on left side navigation, it allows you to pick a specific layout for your site, the default layout option is Seattle that provides “Global Navigation / Top Bar” and a “Quick Launch” side navigation to your site.

Change the site layout from Seattle to Oslo at left side navigation.

The Oslo provides left side navigation in the location of the Global Navigation and the Global Navigation is hidden. This is a perfect layout to use when you wish to have only one set of navigation and would prefer to have more white space on your site to display content.

Click on “Try it out” it will show the preview and then “Yes Keep it”.

Here is the final view of the site after applying Oslo layout (left side navigation in the location of the Global Navigation and the Global Navigation is hidden). 🙂

Creating a Sharepoint 2013 List from an Excel-sheet

In this post I will write about creating a SharePoint list from an excel sheet, Some time you must have come across a situation where your client or manager has an Excel sheet and wants to put it on the SharePoint as a List, We can do that using “Import SpreadSheet App” in SharePoint 2013
The steps are as follows
1. Go to Site Settings -> Add an app, and search for ‘Import Spread Sheet’ app.

2. Add ‘Import Spread Sheet’ app and provide information as shown in below screen. You need to select the excel file.

3. Click on the import, wait for few seconds and your spreadsheet gets imported in list.

Thanks for reading the blog 🙂

Hide the Quick Launch in SharePoint 2013

As we know In SharePoint 2013 the Quick Launch is mandatory but sometime it is useful to ‘turn-off’ the Quick Launch on a specific page but not on the whole site. In these cases we can use a Script Editor Web part in SharePoint 2013.

Add a Script Editor Web part on the page after clicking on Check-out -> Edit the page -> Insert -> Script Editor Web-part

Now edit the Script Editor Web-part and Write the following HTML code to hide the quick launch and then Click Insert.

So now the Quick Launch will disappear and here is the final view of our page

Please note this is good only if you wish to hide the quick launch from one or two pages, if you want to totally remove the Quick launch on your Site then edit your master page.  By default if you haven’t done anything to your SharePoint instance the default master page will be the seattle.master.  Add your codes there and it will disable the quick launch for the whole Team Site.

I hope you find this blog helpful 🙂