Customer List is used to display the details of the various customers. Customer details include Name, Address, Phone number and Customer id.In the basic form details of 6 customers gets displayed. On increasing the number of customer, more forms will be repeated so as to include details of more customers.
- SharePoint 2010 ,
SharePoint list is used as a DataSource for Customer list. SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that SharePoint includes Web Parts that provide simple methods for managing the data. If the data was stored in a database, it would require custom user interface components to access it and manipulate it. Also, specialized skills are required to design, implement, and maintain a custom database. Another advantage of using lists is that custom workflow and event handlers can easily be registered to them.
By default the following columns are available in sharePoint list
• Modified By
• Created By
Apart from these default list columns , user can add more columns depends on requirement.
|List Name||Column Name||Data Type|
Details of the customer are stored in this list.
|CustomID||Single line of text|
|Name||Single line of text|
|FirstAddress||Single line of text|
|SecondAdress||Single line of text|
|Phone||Single line of text|
The order of creation of forms would be RepeaterForm and then the MasterForm. This is because RepeaterForm is configured in the external form used in MasterForm and this form is made to repeat in the MasterForm as required.
|List Of Forms Used|
|MasterForm Form Design Rule Design||MasterForm contains an external form which is used to store the form to be repeated. It also contains a search control used to fill all details of the customer with the Customer List.|
|RepeaterForm Form Design||RepeaterForm contains 6 Border controls. Each border control contains 5 labels for displaying 5 fields(Name,Address,City,Phone number,Customer Id).|
Create a New Form in the CustomerList Folder and open it for editing.
Drag a label to the center of the form ,in first row and name it “CustomerList”.
Drag an External Form in the next row and name it “extCustomer”.
Click on the external form. In the properties window displayed on the right select the Navigate URL by clicking the button shown below.
From the pop screen select the form which has to be loaded in the external form. Here it is Repeater Form. Then click add.
Drag a search control and name it “SrcMaster”.
Name can be given to the controls by clicking on it and editing the “Properties window “displayed on the right side.
Checks if the total row count of search is more
than 6 If total row count is more than 6, the Repeater form is made to repeat (total row count/6) times. Then the variables VarInitial, VarGrid,
VarAdGrid and VarSetGrid are set to value 1.
Runs the “SetFirstGridvalues “rule and
“AdditionalGridvalues” rule.If total row count is less than 6, Set variable
VarInitial and VarGrid value to 1 and
Checks if the VarGrid value is less than or equal
to 6 and VarInitial is less than the total row
count of search. If the condition is true name is set to label
controls within the border through (VLabelName=lblHeader+VarGrid) rule.
VLabelName is the variable which is used to temporarly store the label control name. Next using SetFormValue rule label controls
within the border in Repeater form are assigned values form search control. (Name, address, etc.). Next the value of VarInitial variable and VarGrid variable is incremented by 1.Again run the same “SetFirstGridvalues” rule.
This loop runs till all the fields in the basic
Repeater form get filled with data’s from the
Initially checks if the VarAdGrid value is less
than or equal to (TotalRowCount/6). VarAdGrid variable is used to get the count of repeater forms. Next if the above condition is satisfied, label controls in the repeater form are given name and the values are assigned just as in the “SetFirstGridvalues” rule.
VarSetGrid variable is used to set name for labels. Each time all the controls within the repeater form gets filled VarAdGrid value gets incremented by 1. This rule works as long as the VarAdGrid value is less than or equal to the number of required repeater forms.
Create a NewForm in the Customer List Folder and open it for editing.
Click anywhere on the form to get the form properties loaded in the Properties window.
Change the Name of the form to RepeaterForm. Set the Width of the form to 1200 and Height to 1000.Tick Auto Height in order to adjust the height of the form with respect to the controls in the form.
The user is provided with the details of various customers. The customer details include, Name, Address, Phone number and Customer id. Data used in this example is fetched from sharepoint list, CustomerList .
A how-to is an informal, often short, description of how to accomplish a specific task. A how-to is usually meant to help non-experts, may leave out details that are only important to experts, and may also be greatly simplified from an overall discussion of the topic.
Add Web Part01
Click on Site Settings Wheel in the upper right corner of your site and then select “Site Contents Page”.050607080910
Upload List Template01
On the right corner of the window, click on settings.0203050607