Suppliers contain a dashboard displaying details of various suppliers. This includes fields such as suppliers Contact Name, Company, Phone, Address and Country. On clicking company link a new form gets loaded, where supplier details, product details and order details of that product are displayed. On clicking the link, the Supplier id is passed to the new form which gets loaded. This id helps in the selection of required fields.
- SharePoint 2013
SharePoint List | |||
---|---|---|---|
List Name | Column Name | Data Type | |
ProductList
Details of all the products are stored in this list. |
ProductName | Single line of text | |
UnitPrice | Single line of text | ||
ProductId | Single line of text | ||
Category | Single line of text | ||
SupplierID | Number | ||
IsDiscontinued | Single line of text |
SharePoint List | |||
---|---|---|---|
List Name | Column Name | Data Type | |
OrderedProduct
Details of ordered products are stored within this list. |
OrderID | Single line of text | |
ProductID | Single line of text | ||
Quantity | Single line of text | ||
Discount | Single line of text | ||
UnitPrice | Single line of text | ||
SupplierID | Number |
SharePoint List | |||
---|---|---|---|
List Name | Column Name | Data Type | |
SuppliersList
Details of the supplier are stored in this list. |
Company | Single line of text | |
Contact Name | Single line of text | ||
Contact Title | Single line of text | ||
Phone | Single line of text | ||
Fax | Single line of text | ||
HomePage | Single line of text | ||
Address | Single line of text | ||
Country | Single line of text | ||
Region | Single line of text | ||
City | Single line of text | ||
PostalCode | Single line of text |
List Of Forms Used | ||
---|---|---|
Name | Functionality | |
Repeater Form Form Design Rule Design | Form that gets repeated depending on the number of product. | |
MasterForm Form Design Rule Design | Form that gets loaded on clicking the Supplier Id link in Dashboard form. | |
Dashboard Form Design Rule Design | Displays all the supplier details. |
Create a NewForm in the Suppliers 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. Add a Subform and name it hdnfrm and set the visibility to false. Add two textboxes into the Subform and name them as hdnPID and hdnID. Drag a DynamicGrid and name it dgProduct. Drag a Search Control and name it srcProduct. Configuring the Dynamic Grid: Click on the grid to get the popup menu.
Create a NewForm in the Suppliers 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 MasterForm. Set the Width of the form to 1200 and Height to 1000. Add a sub form and name it hdnfrm and untick the visibility and add a textbox in the subform and name it as hdnId. Also add a search control in to the sub form and name it as srcProduct. Add labels in the MasterForm in order to select supplier’s details. Add an external form and name it extProducts. Click on the external form. In the properties window displayed on the right select the Navigate URL by clicking the button shown below.
ExecuteCommand(Select) is used to fill the labels with supplier details using the supplier id passed to “hdnId” textbox. Fills the hidden search control with product details of corresponding supplier id. Next action is used to check if the total row count of search is greater than 1. If the condition is satisfied, the repeater form is made to repeat that many times. Also a product id is passed to the Repeater form using SetFormValue rule. A variable VRepeater value is set to 1. Next a “SetRepeterValue” rule is ran.
Checks if the VRepeater value is less than the total row count of search, if yes product id value is passed to the repeated form. Next the VRepeater value is incremented by 1. Again the same rule “SetRepeaterValue” is called . This rule works as a loop.
Choosing Link Button opens another section below, where you can choose the form to navigate to when the button is clicked. Enter the folder name where the form is present and search to get that folder alone. Choose the form to be opened, in this case, the Master form. Choosing this form makes this available in the Form Name drop down below.
Contains 3 GridSetRowStyle rule. First one is used to set background color for all rows in the search control. Second one is used to set the header background color of the search control. Third one is used to set the header font color of the search control.