How to Create a Subsite in SharePoint 2013

Hi friends, in this series of SharePoint tutorial, today we are going to learn how to create a subsite in SharePoint 2013. We know that the site is a container of objects which includes lists, document libraries, pages, etc. Site and Subsite both terms are almost the same. Only the difference is, subsite lives underneath the main site. So let us see how to create a subsite in SharePoint 2013.

Create a Subsite in SharePoint 2013

Step 1) Click on Gear button and select Site Contents

click on site content

 

Step 2) A new page will open. It will show all the site contents. Scroll down the page and you will see an option for adding a new subsite. Click on it.

create new subsite in sharepoint 2013

 

Step 3) Now enter your subsite name, description, and template for your subsite. The template is nothing but which type of site do you want. There are different options like Team site, Blank site, Blog and project site. We will see the difference between these types in upcoming posts.

how to create a subsite in sharepoint 2013

 

Step 4) Finally click on Create. It’s done. You can see the newly created subsite under the Site contents as below.

subsite in sharepoint 2013

 

I hope you are now able to create a subsite in SharePoint 2013. If you have any doubts feel free to ask in the comment section. If you have any articles related to SharePoint or any other topic you can share with us and can earn money too!

Difference between SharePoint Farm & Standalone Installation

Hi friends, this article is about SharePoint installation. Different types of SharePoint installation and difference between them. we will also see limitations of each installation type. The main objective behind this article is to become familiar with difference between SharePoint Farm and Standalone installation.

Types of SharePoint Installation

There are two types of SharePoint installation as ‘Standalone’ and ‘Farm’ installation. Standalone installation will install SQL Express on your machine and use it to provide SharePoint services. Farm will install SharePoint on network or on existing SQL server.

Difference between Farm & Standalone Installation

Farm Installation

Standalone Installation

1)      It allows you add servers so as to keep from running out of resources.

 

1)      No additional servers can be added and hence it has limitation of database.

 

2)      Offer greater scalability and performance. Multiple servers like 2008 R2 Express having 10GB of database can be added.

 

2)      Less scalability and performance as compare to Farm installation because only one SQL Server having limit of 4GB of database can be installed.

 

3)      You can join other machines to this installation.

 

3)      No other SP machine can join this installation.

 

4)      You have more control over server configuration.

 

4)       All server configuration will be done automatically using standard settings and local service accounts.

 

Limitations of Standalone Installation:

  1. Standalone installation has SQL database limit of 4GB.
  2. As standalone is configured in one server only so no Domain accounts can be used. It runs under local accounts like Network Service account therefore we can not create user profile services.
  3. We can not backup the data and restore it from standalone installation to multiple servers farm and vice and versa.

If you like this article, please share it with your friends and like or facebook page for future updates. Subscribe to our newsletter to get notifications about our updates via email. If you have any queries, feel free to ask in the comments section below. Have a nice day!

Creating Add Only Permissions in SharePoint 2013

In this tutorial of SharePoint 2013, we will see how to create & set “Add only” permissions for a list or library. By creating add only permissions level users can not edit or delete the item. You can easily create “Add Only” permission level through Permission levels available in Site permissions settings.

Let us see step by step – how to implement this scenario in Share Point 2013 platform.

Step 1: Go to site settings > Site permissions

Site permissions

Step 2: Now click on Permission Levels from the ribbon.

permission levels

 

Step 3: Now you can see default permission levels. There is no option for Read Only permissions. To create new permission level for Read Only click on “Add a permission level”.

create new permission levels add only

Step 4: Now give a name for new permission levels. Type a description for this level. Select an “Add Items” checkbox from the list and click on Create.

create new permission levels add only 2

 

This will create a new Permission level for adding items in the list or library. When we choose this permission for any user he/she can not edit or delete the item.

Setting Add Only Permissions to a list or Library

1) Go to List (or Library) and click on List settings > Permissions for this list and click on “Stop inheriting Permissions”. This will break default permissions set to list or library. Now you can give permissions manually.

Stop inheriting permissions

 

2) Now click on the checkbox in front of user (or group) name for which you want to set permission as “Add only”. I am setting Add Only permission for Restricted Readers (initially they are having only read permissions). Click on Edit User Permissions.

Setting permissions manually

 

3) Now you can see “Only add” option which we created through permission levels. Select it and click OK.

Set Add Only permission

 

In this way, we can set add only permissions for users so that they can’t edit or delete an item.

If you like this article, please share it with your friends and like or facebook page for future updates. Subscribe to our newsletter to get notifications about our updates via email. If you have any queries, feel free to ask in the comments section below. Have a nice day!

How to Make Conditionally Mandatory Field in SharePoint 2013

Hi friends, in the previous tutorial of SharePoint 2013 we have seen how to Show/Hide fields based on the value of other fields. Today we are going to learn how to make Conditionally require data in SharePoint 2013. Have you ever needed to make one or more fields to be mandatory depending on the value of another field? If your answer is yes, then this post is for you! Let us see how to make the Conditionally mandatory field in SharePoint 2013.

Here we are going to make “Favourite flavour” column mandatory when the user selects “Do you like Ice Cream” as YES. If the user selects NO “Favourite flavour” field will no longer remain mandatory. Isn’t it interesting? Let us see how to implement this scenario in SharePoint 2013.

Conditionally Mandatory Field in SharePoint 2013

Let us create a list named “Delicious Desserts”. This list has two columns as “Do you like Ice Cream” as radio buttons and “Favorite Flavor” as a text field. Here we are making “Favourite Flavour” field conditionally required.

New Item Form in Sharepoint 2013
New Item Form in Sharepoint 2013

Now click on List settings > Validation Settings (under General Settings heading).

validation settings in sharepoint 2013
validation settings in SharePoint 2013

Here you can enter the formula for validations. You can also put a message for the user when he tries to save the item without filling that required field.

Now copy the following formula, replace column names with yours and paste it in formula field as shown in the screenshot. Also, set User message so that user can also understand which one is a mandatory field.

=IF([Do you like Ice Cream]="Yes",IF([Favourite Flavour]<>"",TRUE,FALSE),TRUE)
Validation formula in Sharepoint 2013 for Conditionally Mandatory field
Validation formula in Sharepoint 2013 for Conditionally Mandatory field

See below screenshot. Here User gets a message like “Please mention your favorite flavours” when he tries to save the form after selecting YES for the question “Do you like Ice Cream”. In this way, we can implement Conditionally Mandatory field in SharePoint 2013.

Validation for conditionally mandatory fields
Validation for conditionally mandatory fields

If you want to validate multiple fields that depend on two or more other fields, OR condition, AND condition etc. you can easily create a formula by referring to these calculated field formulas.

If you like this article, please share it with your friends and like or facebook page for future updates. Subscribe to our newsletter to get notifications about our updates via email. If you have any queries, feel free to ask in the comments section below. Have a nice day!

How to Create a List & Library in SharePoint 2013 Site

Hi friends, in this short tutorial we will see how to create a list & document library in the SharePoint 2013 site. We all know that SharePoint is used to Share an information and Collaborate with the group of people. We can do this through the use of two apps called Lists and Libraries. So let us first see how to create a List in SharePoint 2013 site.

Creating a List in SharePoint 2013 site

Step 1) Click on Gear Icon available at upper right corner and select Site Contents as shown in the screenshot.

Click on Gear button and select Site Contents
Click on Gear button and select Site Contents

Step 2) Now you can see all the site contents like available lists, libraries, and other apps as shown below. Click on add new app.

Click on Add New App
Click on Add New App

Step 3) Click on Custom List to create a new list in your SharePoint 2013 site.

Click on Custom List to create a new List
Click on Custom List to create a new List

Step 4) A popup will appear to enter a List Name. I have entered Leave Request as List name because we are going to learn how to create Leave Request Workflow using SharePoint Designer 2013 in our next post.

Enter List name and click on create
Enter List name and click on create

You can click on Advanced Options to enter a description for this List.

Step 5) That’s it. Now you are ready to customize your own list. We will see how to customize new list in upcoming posts.

Creating Document Library in SharePoint 2013 Site

Same steps need to be followed for creating Document Library in SharePoint 2013 Site.

Click on Document Library to create a new list in your SharePoint 2013 site.

Click on Document Library to create New Library
Click on Document Library to create New Library

A popup will appear to enter a Document Library Name. Enter a library name and click on Create button. You can click on Advanced Options to enter a description for this library.

I hope you are now able to create a custom list or document library in SharePoint 2013 site. In the next post, we will learn how to create Leave approval workflow using Sharepoint designer 2013.

Let me know if you have any queries through comments. If you liked this article please share it with your friends and like our facebook page for future updates.

Show Hide Fields Based on Dropdown Selection: Sharepoint 2013

In the previous tutorial, we have learned How to Create List and Libraries in SharePoint 2013. Today we are going to learn how to Show/Hide fields based on Drop down selection in SharePoint 2013, which is also implemented in Nintex Form with Rules. This is useful when we need to show or hide some fields depend on the selection of another field (column).

How to Show/Hide Column Fields Based on Other Fields

In this tutorial we are going to hide ‘State’ and ‘City’ fields when the user selects ‘Other’ in Country field with Content Editor Web part i.e. CEWP. Here Country field is drop-down. This method is also applicable to other field types. Let’s see how to hide one field based on another field.

Step 1: Create a new list and insert all the fields in it.

Step 2: Open the new item form and click on Edit Page option as shown in the screenshot.

edit page in sharepoint

 

Step 3: Click on Add a Web Part > Media and Content >Content Editor > Add.

Add content editor

Step 4: Click on Edit Source

Click on edit source

Step 5: Download jquery.min and sputility.min and upload it to your Document library.

Step 6: Paste this code in that Edit source section.

<script src="/sites/abc/Style%20Library/jquery.min.js"></script>
<script src="/sites/abc/Style%20Library/sputility.min.js"></script>
<script>
 $(document).ready(function(){
 var country = SPUtility.GetSPField('Country');
 var HideOrShowOthersField=function(){
 var countryValue = country.GetValue();
 if(countryValue=='Other')
 {
 SPUtility.GetSPField('State').Hide();
 SPUtility.GetSPField('City').Hide();
 }
 else
 {
 SPUtility.GetSPField('State').Show();
 SPUtility.GetSPField('City').Show();
 }
 };
 HideOrShowOthersField();
 $(country.Dropdown).on('change',HideOrShowOthersField);
 });
</script>

Step 7: Replace Red colored link with uploaded links. See below screenshots. Do it for both JQuery and SPUtility.min.js)
Copy link

Step 8: Click on stop editing

Click on stop editing

Here is the result. Now you can see When we choose Other in Country field State and City is hidden. When we choose India in Country State and Country fields Appear.

Hide fields

Show Hidden fields

If you like this article, please share it with your friends and like our Facebook page for future updates. Subscribe to our newsletter to get notifications about our updates via email. If you have any queries, feel free to ask in the comments section below. Have a nice day!

What is SharePoint 2013 and its Applications

Hi friends, in this article we are going to learn what is SharePoint? Most of the people find it difficult to describe what exactly SharePoint is? And yes it’s true that it is little difficult to explain the things about SharePoint. Unless you try to use SharePoint for a little while, it will be difficult to get into it. So let us see what exactly a SharePoint is?

What is SharePoint 2013?

If you are finding some simple definitions about What is SharePoint?, or some simple sentences about SharePoint then you won’t get it from this article (and not anywhere too!). This is because SharePoint is not a simple thing to explain with the help of definitions.

Make sure that “SharePoint is not a Program or Programming language it’s a Platform”. It is a huge collection of many products and technologies that are combined and named SharePoint. It’s a massive set of solutions that you can do with this platform. The list of these solutions is endless because, with different versions of SharePoint, Microsoft is adding different features and solutions.

Ok, without wasting too much time let us see what is SharePoint? Learning SharePoint is just like Learning Microsoft Office. Just like there are different applications in Microsoft Office like Word, Excel, PowerPoint, etc, SharePoint also has such applications. The difference between Office and SharePoint is, you can’t install SharePoint on your local machine, unlike Microsoft office. It is installed on one common server and all your working machines are connected to it.

There are some associated programs like Microsoft SharePoint Designer 2013, Microsoft SharePoint workspace 2013, etc. Which you need to install on your machine to use SharePoint but not always. These are not necessary programs unless you want to do some extra stuff (which we are going to learn in upcoming posts) with the SharePoint.

What does SharePoint Do?

SharePoint can be explained with different areas like Sites, Communities, Content, Search, Insights, and Composites. Let us see these areas one by one.

SharePoint Features
SharePoint Features
  • Sites: Yes, SharePoint can build Websites. To create a Website using SharePoint you don’t need to be a programmer or designer. Unlike normal websites that users can read only, SharePoint websites allow users to contribute, edit, join, etc them. Examples of some SharePoint websites are http://www.h10hotels.com/, http://www.immi.gov.au/, http://www.phs.org/, etc.
  • Communities: SharePoint allows to work as a community. If you have a word document on your website. Hundreds of people can edit that document simultaneously. If you have your organization information, multiple people can contribute their knowledge at the same time. It can give you a shared calendar, shared task board, etc. It also keeps the track of information about when the content is modified and by whom.
  • Content: SharePoint allows you to upload content on it. Whether it is an image, audio, video, documents, etc. SharePoint can store these contents easily. You can make particular content accessible to a particular person or group. You can set permission to allow some people to edit the content. That means SharePoint provides full control over the content for its users. You can edit documents directly in a web browser which are stored on SharePoint server.
  • Search: As we discussed SharePoint can do countless things, so sometimes it becomes difficult to navigate or to find something on SharePoint website. To overcome this difficulty SharePoint provides the function of the Search engine. It can search anything available on that site related to your search keyword.
  • Insights: SharePoint brings all the information together to understand it better. It can build graphs, spreadsheets, flowcharts, dashboards, scorecards to make the data more. Understandable.
  • Composites: We all know that there is no such platform, operating system or program that exactly knows what you want. But SharePoint has some capabilities which can help to do this. To make it customizable you don’t need to be a programmer. Using SharePoint designer or SharePoint Visio you can build workflows or you can make different forms. And you know programming you can do many things apart from this.

SharePoint 2013 Applications:

  • Enterprise Content and Document Management
  • Business intelligence
  • Personnel cloud
  • Internet and corporate social network
  • Extranet and web content management
  • Software framework

If you like this article, please share it with your friends and like our facebook page for future updates. Subscribe to our newsletter to get notifications about our updates via email. If you have any queries, feel free to ask in the comments section below. Have a nice day!