SharePoint4us

Explore the Experience in SharePoint 2013

Showing posts with label Custom List. Show all posts

Tuesday, November 17, 2015

Item Level Permissions in SharePoint 2013


Hi friends,


In this article we can explore a common scenario which can be solved using OOB feature of SharePoint 2013.

Scenario

You have a list to track expense claims. Multiple employees are using the same list. Following are the challenges:
1. Employees should see only their items
2. Employees should not be able to edit other employee’s items

Solution
Although using “views” will be the first solution in mind, we can solve this through OOB way using:
· List Item Level Permissions

Steps

Create an Expense list as shown below.









Save changes & test it out in following way
1. Create 2 users
2. Use 2 browsers
3. Add one expense-item for each user
4. You can see user-1 can see only his/her item
5. Same applies to editing as well

When user 1 logs in:



Tuesday, December 16, 2014

What is the Content Type for Custom List in SharePoint 2013, SharePoint 2010



Hi Guys,

Thanks for visiting our blog .
 
Every Custom List is having a content type inherited in it . For Custom Lists in  SharePoint the default content type is "item".

If we want to see the content type associated to list .

Go to    List Settings
                  --->Advance Settings(Under General Settings)
                                                                          ---> Allow Content Types
                                                                                            -->Select Yes radio button.
                       


Then   you  can able to see the content type associated with the list .
                    
                     


If You want to know the content type id  just  click on the content type (item).




What is calculated column in SharePoint 2013 ,2010

Hi Guys,

Thanks for visiting my blog .

While creating  Columns in Custom List  many of us have seen the Calculated  Column .

I will describe the calculated column for Month and year .

Go to the list settings and then click on Create column to add a new column. Give the column name and chose the column type as calculated column. Then in the formula write like below:
=TEXT([Created],"yyyy")



he above formula will return the formula as a single line text, Now if you want to return as integer then you can write the formula like below:

=YEAR(Created)

Similarly
 if you want to store month then follow the above step and write the formula like below:

=Text(Created, "MMMM") : This will return the full month name
=Text(Created, "MMM") : This will return first 3 letters of the month name
=Text(Created, "MM") : This will return integer month

If you want to return the value as an integer then you can write the formula like below:
=MONTH(Created)


Now if you will check the output will come like above :