Lookup Archives - gettectonic.com

07Jun

Field Types to Custom Report Type

How to Add Fields to a Custom Report Type If a report based on a Custom Report Type is missing some fields, you’ll need to edit the layout of the report type to make those fields available. For example, if an ‘Activities with Accounts and Contacts’ report type lacks certain fields in the ‘Select Columns’ step of the Report Builder, follow the steps below to resolve this. Steps to Add Missing Fields to Your Custom Report: Note: When previewing the layout, you’ll see all fields and objects, even those you don’t have permission to access. You can only access data stored in fields or objects that you have the appropriate permissions for. Once you’ve completed these steps, the missing fields will be available in the report. Additional Resources For more tips, visit the Salesforce Help page: Design the Field Layout for Reports Created From Your Custom Report. You may also want to explore more about creating a Custom Report Type and Standard Report Types for further customization. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Service Cloud with AI-Driven Intelligence Salesforce Enhances Service Cloud with AI-Driven Intelligence Engine Data science and analytics are rapidly becoming standard features in enterprise applications, Read more

June 7, 2024in Salesforce

21May

AMPScript Editor Explained

What is the Purpose of AMPscript? AMPScript Editor Explained. AMPscript serves a multitude of purposes, primarily focusing on personalization within Salesforce Marketing Cloud. This scripting language empowers users to personalize their emails by integrating subscriber or contact data. From addressing recipients by their first names to tailoring content based on individual preferences, AMPscript enhances the overall effectiveness of marketing campaigns. Exploring Inline AMPscript Inline AMPscript represents a specific use of AMPscript, distinguishing itself from AMPscript blocks. While AMPscript blocks can contain multiple lines of code, inline AMPscript typically serves a single function. The output of this function appears at the code’s location within the message. Noteworthy, inline AMPscript supports nested functions, contributing to its versatility. Understanding AMPscript in Salesforce Marketing Cloud AMPscript is Salesforce Marketing Cloud’s proprietary scripting language, prized for its ease of learning and its capacity to facilitate personalization across diverse digital marketing channels. It seamlessly integrates within HTML emails, text emails, landing pages, SMS messages, or push notifications. However, Salesforce Marketing Cloud lacks dedicated tools for editing AMPscript, both within and outside the user interface, resulting in a somewhat rudimentary and error-prone script-writing experience. Enhancing the AMPscript Editing Experience To improve the AMPscript editing process, various tools and extensions have been developed: Retrieving Data with AMPscript To fetch data from a data extension using AMPscript, the Lookup() function is employed. This function necessitates parameters such as the data extension name, the column for data retrieval, and the columns utilized for search and value specification. Like1 Related Posts 50 Advantages of Salesforce Sales Cloud According to the Salesforce 2017 State of Service report, 85% of executives with service oversight identify customer service as a Read more Salesforce Data Studio Data Studio Overview Salesforce Data Studio is Salesforce’s premier solution for audience discovery, data acquisition, and data provisioning, offering access Read more How Travel Companies Are Using Big Data and Analytics In today’s hyper-competitive business world, travel and hospitality consumers have more choices than ever before. With hundreds of hotel chains Read more Integration of Salesforce Sales Cloud to Google Analytics 360 Announced In November 2017, Google unveiled a groundbreaking partnership with Salesforce, outlining their commitment to develop innovative integrations between Google Analytics Read more

May 21, 2024in Salesforce Marketing Cloud

27Oct

Salesforce Connect

Salesforce Connect is a comprehensive integration tool, offering users access to external data through the utilization of external objects and three distinct adapters: cross-org, OData, and Apex custom adapter. This tool ensures seamless data integration across system boundaries, allowing users to view, search, and modify data stored outside the Salesforce org. For instance, if data resides in an on-premises enterprise resource planning (ERP) system, instead of duplicating it within the org, external objects facilitate real-time data access through web service callouts. Salesforce Connect Salesforce Connect, as a robust App Cloud integration service, empowers Salesforce application users to effortlessly interact with and manage data from external sources without leaving the native Salesforce environment. It enables fetching data from both on-premise applications and cloud-based sources. Users can establish connections to external data sources for all Salesforce org users through a single login account or create separate login accounts for individual users. This native Salesforce integration tool is designed to connect legacy databases, ERP systems, and various data sources to Salesforce. Unlike traditional methods involving data copying into the Salesforce org using ETL tools, Salesforce Connect maps external objects directly to data tables in external systems, providing on-demand and real-time access without unnecessary data duplication. It is particularly recommended when dealing with large volumes of data that shouldn’t be copied into the Salesforce org, requiring small amounts of data at any given time, or necessitating real-time access to the latest data. SFDC Connect and Lightning Despite external data storage, Salesforce Connect seamlessly integrates with the Lightning Platform, making external objects available for use in Salesforce tools, such as global search, lookup relationships, record feeds, and the Salesforce mobile app. These external objects can also be accessed through Apex, SOSL, SOQL queries, Salesforce APIs, and deployed via the Metadata API, change sets, and packages. For example, if you have product order information stored in an ERP system, SFDC Connect facilitates the creation of a lookup relationship between the customer object and the external object for orders. This enables the display of order-related lists on each customer record. Additionally, you can update orders directly from the related list on the customer record by configuring the external data source to allow writable external objects. Two Capabilities Two notable capabilities of Salesforce Lightning Connect include the ability to read/write from anywhere, allowing real-time interaction with external sources, and the provision of custom adapters for any web API, enabling developers to link Salesforce with various web APIs. SFDC Connect also offers connectors to connect multiple Salesforce orgs across the company. MuleSoft Contrasting SFDC Connect with MuleSoft, during real-time data retrieval, Salesforce enforces validation rules for incoming data, while MuleSoft applies necessary transformations, such as field mappings and conversions, to the datasets. Like1 Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Service Cloud with AI-Driven Intelligence Salesforce Enhances Service Cloud with AI-Driven Intelligence Engine Data science and analytics are rapidly becoming standard features in enterprise applications, Read more

October 27, 2021in Mulesoft

19May

Case Management in Salesforce

What does Salesforce Case Management entail? Salesforce Case Management, as explained in the Service Cloud Introduction session, provides a platform for recording, tracking, and resolving customer issues across sales, service, and support. Advantages of utilizing a case management system: Case Management in Salesforce Salesforce Case Management allows the automatic collection of cases from various sources like email, social media, support centers, or web forms. It provides tools for categorizing, filtering, and adding notes to cases stored in the database. How can I establish case management in Salesforce? Utilize queues and automated rules to assign cases to your team without constant monitoring. By assigning cases to a queue, specific team members can select cases from a list, helping prioritize work. Auto-assign cases to queues or team members based on conditional rules. Distinguishing case management from CRM: While both case management and CRM assist in managing customer data and interactions, the key distinction lies in the fact that case management is tailored to monitor the progress of individual cases. Visibility of cases in Salesforce: If the organization-wide sharing default access for Cases is set to ‘Private,’ and ‘Grant Access Using Hierarchies’ is enabled, only the Case owner, the owner’s managers in the role hierarchy, Salesforce admins, and user profiles with the ‘View All’ object permission on Cases can view a Case. Can leads have cases in Salesforce? To associate a Lead with a Case, create a custom lookup field on Cases to the Leads object. This allows for a Cases related list on the Lead record. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Service Cloud with AI-Driven Intelligence Salesforce Enhances Service Cloud with AI-Driven Intelligence Engine Data science and analytics are rapidly becoming standard features in enterprise applications, Read more

May 19, 2021in Data, Salesforce, Salesforce Service Cloud

salesforce marketing cloud interaction studio

28Apr

Ampscript

What is AMPscript used for in Salesforce? What is its purpose? AMPscript is a useful scripting language that you can use across emails, landing pages, SMS, and push notifications in Salesforce Marketing Cloud Builders. AMPscript is Marketing Cloud‘s proprietary scripting language for advanced dynamic content in emails, landing pages, SMS, and push messages. Why use Marketing Cloud AMPscript? AMPscript allows you to extend Marketing Cloud functionality beyond its out-of-the-box capabilities because you can develop code and custom solutions, tailored to your own specific needs and requirements. What are some functions you can perform with AMPscript? Types of Functions in Marketing Cloud AMPscript: What are advantages of AMPscript compared to Ssjs? For the web developer who are new to both languages, for them AMPscript has a shorter learning curve compared to SSJS. AMPscript should be preferred for simple inline personalization, which includes content like name, salutation and simple IF ELSE loops. Using AMPscript To use AMPscript, you insert it into the content body of your messages at the point where you want it to render. When you send a message that contains AMPscript, Marketing Cloud Engagement interprets the code and substitutes it with the output of the AMPscript function. 3 Way to Add There are three ways to add AMPscript code to your content: by using inline code, by adding code blocks, or by using tag-based scripting. The first two of these methods use special delimiters to denote the beginning and ending of the code that you want Marketing Cloud Engagement to interpret. In the third method, you delineate the AMPscript code with <script> tags. When you close an AMPscript block, use the same type of closing delimiter as you used to open the block. For example, if you open a block using tag-based scripting, you can’t close it by using the closing code block delimiter. Use the %%= and =%% delimiters to add AMPscript code inline with your content. Inline AMPscript is frequently used within HTML tags to dynamically populate the content of a message. In this basic example, a section of AMPscript is included inline within an HTML <p> tag. You can also include multi-line blocks of AMPscript code in your messages. Use the %%[ and ]%% delimiters to begin and end a code block, respectively. With a code block, you can define multiple variables and execute multiple functions. Code blocks use the syntax shown in this example. Tag-based syntax for AMPscript standardizes the syntax used to declare AMPscript blocks with the syntax of Server-Side JavaScript (SSJS). This syntax makes it easier for developers to switch between AMPscript and SSJS. Like1 Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Service Cloud with AI-Driven Intelligence Salesforce Enhances Service Cloud with AI-Driven Intelligence Engine Data science and analytics are rapidly becoming standard features in enterprise applications, Read more

April 28, 2021in Salesforce Marketing Cloud

08Jun

Lookup Relationship in Salesforce

What is Lookup relationship in Salesforce? Salesforce’s lookup relationships is a significant capability that allows users to connect two objects and establish a parent-child relationship between them. To effectively manage records, this feature is essential for organizing your data. What are the different types of lookup relationships in Salesforce? A Lookup relationship is a type of relationship that simply joins two things together such that you may “look up” one object using the associated elements on another object. There are two types of lookup relationships in salesforce that is: one-to-one and one-to-many. A one-to-one relationship might be a contact related to an account. A one-to-many relationship might be locations related to an account. What does a lookup relationship do? With a lookup relationship, you can: Link two different objects. Link an object with itself (except for the user object; see the Hierarchical section in this topic). For example, link a custom object called Bug with itself to show how two different bugs are related to the same problem. What is the basic difference between lookup relationship and master detail relationship? It does not depend on any other objects, whereas a master-detail relationship has an association with other records. On the other hand, the lookup relationship is just a reference. It can be even blank or NULL. In the database, we can pull the data from particular fields based on the reference keys easily. How many Lookup relationships are allowed in an object in Salesforce? You can have a maximum of 40 lookups on an object. You can have a maximum of two master details on an object. No cascade delete. How does lookup work in Salesforce? Lookup fields appear with the search icon on record edit pages. Clicking the icon opens a lookup search dialog that allows you to search for the record that you want to associate with the record you’re editing. There are two main types of lookups: standard and enhanced. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Service Cloud with AI-Driven Intelligence Salesforce Enhances Service Cloud with AI-Driven Intelligence Engine Data science and analytics are rapidly becoming standard features in enterprise applications, Read more

June 8, 2019in Salesforce, Salesforce Optimization, Salesforce Sales Cloud, Salesforce Service Cloud

Lookup

Field Types to Custom Report Type

AMPScript Editor Explained

Lookup Relationship in Salesforce

Recent Posts

Salesforce Introduces Agentblazer Status

Google Expands AI Search Capabilities with Gemini 2.0

Salesforce Introduces AgentExchange

When to Use AI Agents and Copilots

9 Essential Salesforce Clouds for Healthcare Payers

Contact Us

Be in touch today — and start your business on a path to success.

Category

Archives