- August 12, 2014
- Posted by: Gopinath Narayanan
- Category: CRM, Microsoft Dynamics CRM
These steps help you display excel sheet like table on entity form in the form of grid like structure.
Step 1 Create an look up field (Relation with any entity). As shown in fig 1
Step 2 Make look up field as mandatory after placing field on from. As shown in fig 2 an 2.1.
Step 3 continued……
Step 4: Add sub-grid into newly created tab or any where on the entity form based on your requirement and set properties like shown in fig 3.
In Data source Section
Records= Related Records only
Entity= Combination of schema name and look up field name select that.
Default view= select and edit according.
Step 5. Edit or Add new columns (as shown in below fig) according to requriment in grid view which is located in Data source section in grid properties dialog box
In Data source select
Default view= select and edit view according to your requirement.
Step 6. Continued..
Editing View by adding new columns adding filter to view. And Save As a new view. As shown in fig 3.2.
Step 7. Select the newly created view from grid properties dialog box as shown in below fig
Step 8. Save and publish the form. Gird will appear according to your view but it will be in disabled state. As shown in fig 5
- Above grid will be activated after saving entity record.