Posts

Dynamic Web View of a SharePoint List Item using Excel Web Access Web part

Image
Sometimes customer would like to see the SharePoint list item with a specific design instead of default view for which developer develop a app or web part to achieve it. But in this example, I will show you how to create a dynamic web view of a SharePoint list item using Excel Web Access Web part. Imagine a customer requirement is as below: A State Government would like to start "Develop my Village" program for which they would like to gather information of all the villages(from each department) and store it in Database. After that they would like to view each village information in a village report card format and share it to Central government for review. Let's follow the below steps to store the village information in a SharePoint list and view the SharePoint list item in a village report card format. Step 1:  Create a Village list in SharePoint site with set of columns. Screenshot  for your reference: Step 2: Add a New Item and fill a vi

Customize SharePoint List form into Wizard style

Image
In this example, we will create a list and show the list columns in a wizard style. Follow the steps. Step 1.  Create an  Employee  list with the set of columns. I have created 24 columns to show them in 6 steps in a wizard. By default, If you click on the  new item  in the Employee list, the web form looks like below. Screenshots for your reference   Step 2.  Enable  content type  in Advanced settings in the Employee list. Click on  Item  content type and then click on  Column order  to set the position of each column to show in the right position in the wizard. In this example, I have created 24 columns to show them in below 6 steps. Employee: Basic Details  (Contains 8 columns) Employee: Project Details  (Contains 3 columns) Employee: HR Details  (Contains 3 columns) Employee: Finance Details  (Contains 3 columns) Employee: Insurance Details  (Contains 4 columns) Employee: Passport Details  (Contains 3 columns) To show the specific co