SmallBuilder Help
AppExchangeContact Us
πŸ‡ΊπŸ‡Έ English
πŸ‡ΊπŸ‡Έ English
  • SmallBuilder Help
  • Getting started with SmallBuilder
    • License and Permission Set Assignment
    • Organization Currency Setup
    • Connected App Configuration
  • πŸ“¦SmallBuilder Line Items
    • Release Notes
      • '25 Update
        • v 1.38
        • v 1.37
    • SmallBuilder Line Items Overview
    • Getting Started
      • Assigning Licenses and Permissions
      • Organization Currency Setup
      • Connected App Setup
    • Builder
      • Getting Stared with the Builder
      • Default Setting
        • Responsive Screen Configuration for Devices
        • Adjusting Editor Screen Ratio
        • Modifying Editor Labels
        • Lookup Selector Settings
          • Search All on Load
          • Expand Filters by Default
          • Allow Select Duplicate Item
          • Caching to Improve Performance
          • Records Per Page
        • Line Item Editor Settings
          • Show Summary
          • Freeze First Column
      • Builder Setup Steps
        • Relate Objects
          • Parent Object
          • Line Item Object
            • Set Object and Parent Reference Field
            • Set Filters and Sorting for Saved Line Items
            • Control Line Item Deletion
            • Set Auto-Numbering
          • Lookup Object
            • Select Lookup Reference Field
            • Set Keyword Search
            • Block Lookup Selector
            • Set Filters and Sorting for Lookup Records
        • Setup Lookup Selector
          • Add Columns
          • Reorder Columns
          • Change Column Labels
          • Set Column Width
          • Change Text Alignment
          • Add Virtual Columns for DataSource
        • Setup Line Item Editor
          • Add Columns
          • Reorder Columns
          • Change Column Labels
          • Set Default Value
          • Source Field: Assigning Default Values from Parent or Lookup Fields
          • Set Column Width
          • Change Text Alignment
          • Set Field Input to Read-Only
          • Set Field Input as Required
          • Display Totals
          • Hidden Setting for Line Item Editor Columns
          • Exclude Certain Fields from Saving
        • Preview
        • Activate
        • Create Button and Add to Page Layout
      • DataSource
        • Basic DataSource: Retrieve Related Object Data
        • Advanced: Retrieve Data Using Apex Classes
      • Cloning the Builder
      • Resetting a Builder
      • Insert Filters Using the Query Wizard
      • Inserting Custom Labels into Editor Labels
    • Product Option
      • Product Option Setup Steps
        • Activate Product Options
        • Configure Product Options
          • Default Setting
          • Line Item Setting
        • Configure Product Option Data
      • Display and Storage of Line Item Option Values
    • Use Cases
      • Utilizing the Editor’s Aura Component
    • FAQ
  • πŸ“¦SmallBuilder Lists
    • SmallBuilder Lists Introduction
    • Getting Started with SmallBuilder Lists
      • Assigning Licenses and Permissions
      • Organization Currency Setup
      • Connected App Setup
    • Getting Started with Builder
    • Builder Setup Steps
      • Default Setup
        • Title
        • Legend
        • Allow Export
        • Allow Import
        • Show Icon
      • Datatable Setup
        • QUERY
        • Multi Selectable
        • Show Summary
        • Add and Edit Columns
          • Column Editing by Type
        • Add Virtual Column
        • Add Row Action
      • Data Import Setup
      • Action Setup
        • Add Action
      • Filter Setup
        • Add and Configure Filters
          • Filter Editing by Type
      • Compact Configurator Setup
        • Add and Configure Columns
          • Editing by Column Type
      • Mobile Setup
      • DataSource Setup
        • Basic DataSource
          • Add and Configure Actions
        • Advanced DataSource
          • Writing an Apex Class
      • List Deployment and Management
        • Creating a List Configurator Manually
  • πŸ“¦SmallBuilder Documents
    • SmallBuilder Documents Introduction
    • Quick start
    • Components
    • Data Merge
      • Data Merge - Text
      • Data Merge - Related List
    • Document Job
    • Basic usage examples
      • How to pin a logo image to the top of the page
      • How to leave a gap between the components
      • How to add separators between the components
    • Advanced usage examples
      • Creating an invoice template
      • Automatically email invoices with a trigger
    • FAQ
    • 🌟Release Note
      • '24 Update
        • v. 1.50 ~
  • πŸ“¦SmallBuilder Schedules
    • SmallBuilder Schedules Introduction
    • Quick start: creating a new Schedule configurator
    • Detailed setup guide
      • Basic settings (Side Panel)
      • Linked objects setup
      • Control Field setup
      • Schedule Object setup
      • Saving and activating
    • FAQ
  • ❓SmallBuilder Troubleshooting
    • SmallBuilder Troubleshooting Help
      • Add Button Warning (If the button is not added to the page)
      • Add Tab Warning (Tabs are created and added to the app, but not visible)
Powered by GitBook
On this page
  • Basic DataSource Settings
  • Actions
  • Example

Was this helpful?

Export as PDF
  1. SmallBuilder Line Items
  2. Builder
  3. DataSource

Basic DataSource: Retrieve Related Object Data

PreviousDataSourceNextAdvanced: Retrieve Data Using Apex Classes

Last updated 4 months ago

Was this helpful?

If you want to simply fetch related object data, consider using Basic DataSource settings. You can select an object related to Lookup or Line Item and map the fields of the retrieved object to the Lookup or Line Item fields via DataSource.

Basic DataSource Settings

No.
Attribute
Description
Req.

1

Source Object

Specify the Salesforce objects that you want to source data from.

βœ”

2

Query

Click the Wizard button to open the Build Query layout. You can use the Query Wizard to easily build queries by searching for the correct fields to use. Filters are entered in the format of a SOQL WHERE clause.

3

Evaluation Event

Set the execution timing for the DataSource.

  • On Initialization: Executes when a new Line Item is added.

  • On Loading: Executes when the Line Item screen is loaded.

  • Before Save: Executes before a Line Item is saved.

4

Active

Turns the DataSource on or off. It must be active to be used.

βœ”

5

Map the fields from the DataSource object to the Lookup or Line Item fields.

βœ”

Actions

Actions involve mapping the data fetched from the DataSource to the fields in Lookup or Line Items. Through these actions, the DataSource values are applied to the designated fields.

No.
Attribute
Description
Req.

1

Order

Specify the order that mappings are carried out.

βœ”

2

Source Field

Select the field from the DataSource object.

βœ”

3

Target Field

Select the target field in Lookup or Line Item where the data will be mapped.

βœ”

4

Key

The unique identifier used for mapping data between the DataSource and Lookup or Line Item. The Key determines the target for the mapped DataSource values.

βœ”

Example

This example demonstrates the configuration of a Line Item Editor for Opportunity Products:

  • Parent: Opportunity

  • Line Item: OpportunityLineItem

  • Lookup: Product2

When the Lookup Object is set to Product2, users often want to display UnitPrice information. However, in Salesforce, the UnitPrice is stored in the PricebookEntry object, which is a child object of Product. Since UnitPrice cannot be fetched via a formula field, we use a DataSource to query the related PricebookEntry data.

  1. In the DataSource settings, specify the Source Object as PricebookEntry.

  2. (optional) Click Query Wizard to set up the query conditions: IsActive = true AND Pricebook2Id = {$Parent.Pricebook2Id}

  3. To match the PricebookEntry data to the Products, use the following settings:

    • Source Field: Product2Id

    • Target Field: Id

    • Key: true

    • Source Field: UnitPrice

    • Target Field: SBLI_Virtual1

Available only for Line Items.

To display the Unit Price alongside the product data, add an Action and map the fields to a in Lookup:

πŸ“¦
virtual column
❗
Actions