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
  • Line-item Object Advanced Setting
  • Lookup Object Filter

Was this helpful?

Export as PDF
  1. SmallBuilder Line Items
  2. Detailed setup guide (Backup)

Linked objects setup

Last updated 4 months ago

Was this helpful?

To implement the Line-item Configurator, you first need to specify a Parent object, a Line-item object, and a Lookup object.

For example, if you want to build a configurator to allow you to add products to an opportunity, you would set the Parent object to the Opportunity object, the Line-item object to the Opportunity Product object, and the Lookup object to the PriceBookEntry object.

Item
Description
Req.

Parent Object

The object to which you want to add a line-item configurator, such as an opportunity, quote, or business trip. The line-item configurator will let you add lines (representing e.g. products or expenses) to this Parent object.

βœ”οΈ

Line-item Object

The Line-item object is the Junction which connects the other two objects. For example, the OpportunityProduct, QuoteLineItem, OrderItem objects.

βœ”οΈ

Lookup Object

This is the object referenced by the line-item, such as a product, customer, expenses etc.

πŸ’‘ Tips In the case that you only want users to edit existing items, and not be able to add new line items, you can tick Block adding items. Otherwise the editor will include a Lookup Selector tool to add new items.

If you want to block only some items, you can specify the API name of a true/false API field.

You can also specify which fields the user can search through.

If you want to pre-filter the available options, you can write a SOQL filter using the API name of the Parent field in the Advanced Condition box. For example: Product2.Name like '%Generator%'.

βœ”οΈ

Line-item Object Advanced Setting

Settings for importing saved records from the Line-item Editor, including sorting and deletion control.

Item
Description

Order By

Sets the sorting when returning records for a saved line-item. Enter the ORDER BY clause in SOQL.

For example, if you want results to appear in descending date order, you can write CreatedDate DESC.

Delete Controller Field

This controls the deletion of Line-item records based on the specified field value. The field must be a Line-item field with a value of true or false.

For example, if you want to control the deletion of Line-item records based on a field in the Parent or Lookup object, you can create a Boolean-type formula field on the Line-item object.

Lookup Object Filter

Controls how the user adds items in the Lookup Selector, including filters.

Item
Description
Req.

Keyword Field

Select the field which the user can use to search for Lookup records, for example a Product Name or Code.

βœ”οΈ

Match Condition

Choose whether the user's search will return any values that contain the search string, or only values which start with exactly the search string. Default is "Contains".

βœ”οΈ

Order By

Sets the sort order for the search results.

Enter the ORDER BY clause in SOQL.

For example, if you want to search in ascending order by product code, you can write ProductCode ASC.

Advanced Condition

Specify a pre-filter condition to restrict the results users will see. Enter the WHERE clause in SOQL.

For example, if you want users to see only records that are active (field: isActive), you can write IsActive = true.

If you want users to only be able to see records with certain names or product codes, you could write something like this:

Product2.Name like '%Generator%' πŸ’‘ Tip If you want to specify a field value from the Parent object in your filter, you can bind it using {$Parent.FieldName}.

For example, if you want the user to only be able to look up records that match the currency of the Parent object, you could write something like this:

CurrencyIsoCode = {$Parent.CurrencyIsoCode}

πŸ“¦