Field Set Grid

GridMate provides a lightning grid component GM - FieldSet Grid to display list of records with advanced features and bypass Salesforce standard UI limitations like the number of columns, number rows and displaying parent fields without writing formulas.

In this tutorial, we will create a grid of contacts using GM - FieldSet Grid to bypass the Account Contact Relationship. With this grid, we will get an instant access to the contact records.

1. Open the contact object in the object manager.

2. Add a FieldSet (GM ACR FieldSet) with the right fields to display including parent fields.

3. Go to an account record and edit the page in the app builder.

4. From the components list, drag and drop the component GM - FieldSet Grid.

5. The grid component is now ready for configuration in the Lightning App Builder.

6. The property values can be configured to tailor the data grid to the needs of the end-user.

7. To perform a quick configuration, populate required property values:

   • Related Object Name : Contact

   • FieldSet Name : GM_ACR_FieldSet

   • Custom Label : Contacts

   • Row Limit : 100

   • Page Size : 50

   • Grid Height : 480

   • Filter : {"Id":{"operator":"in","value":"SELECT ContactId FROM AccountContactRelation WHERE AccountId=$$recordId$"}}

   • Search Fields : FirstName,LastName,Title

   • Wildcard Search : Checked

   • Show Border : Checked

   • Show Column Border : Checked

Below is a step by step tutorial to configure the GM - FieldSet Grid component..

GM - FieldSet Grid