Customized field for displaying Pricing in Item Group record

JIRA CODE : BGG-120

Description

We need to display a custom field in the Item group which should display the total price of its components. If the item group contains 3 items A, B and C then we need to populate the amount value sum of individual prices A+B+C to that field.

Solution

A. Generate the Item Group Price (total) by creating a Saved Search

1. Navigate to Lists > Search > Saved Searches > New 
2. Click Item
3. Click Criteria tab > Standard subtab, add the filter:
   • Type = is Item Group
4. Click Results tab > Columns subtab, add the following fields:
   • Formula (Numeric) | Sum | {memberquantity} * {memberitem.price}
   • Internal ID | Sum
5. Click Available Filters tab, add the filter:
   • Internal ID | Show in Filter Region
6. Edit Search Title to “Group Price”
7. Click Save & Run

B. Display the Group Price on the Item Group record:

1. Navigate to Customization > Lists, Records, & Fields > Item Fields > New
2. Set the following:
   • Label = Group Price
   • Type = Free-Form Text 
   • Store Value = False/Disabled
   • Applies To = Group
3. Click Validation & Defaulting tab > Search field > select Group Price
4. Click Display tab > Subtab field > select Main 
5. Click Save