Webinar Alert : Mastering  Manual and Automation Testing! - Reserve Your Free Seat Now

- Salesforce Blogs -

What are Field Dependencies? How to create Field Dependency in Salesforce?

Introduction

There are times when people have to pick something from a drop-down list and he has to keep scrolling to find the relevant values as per his interests and preferences. The reason is that almost everything is included in the list and it is too long to check out. So, the process is not only time consuming but it is stressful too. Here, the concept of field dependency in Salesforce comes into play where you can refine your search from the drop-down list based on filters.

In this blog for how to create field dependency in Salesforce, let us first discuss what is field dependency in Salesforce, a variety of data types to define the field dependency Salesforce, step by step guide to field dependency Salesforce lightning creation, How Field dependencies work in the Salesforce, etc. Before we go into depth, let us start our discussion with a quick definition of Field dependency Salesforce Lightning.

What is Field Dependency in Salesforce?

You must be wondering what is field dependency in Salesforce? Field dependencies in Salesforce are the special type of filters that help us to change the content of a picklist based on the value of another field. For example, instead of displaying all possible options for a country in a single picklist, it is always great to limit the values to display based on the value of other fields like the State. This is an excellent style to pick the right option quickly and more conveniently.

Another example can be taken for the food items where deciding from the long list is usually time-consuming and boring, you can limit the search by keywords like breakfast, lunch, dinner, etc. The values for picklist could be defined as controlling fields and dependent fields as shown below:

Read: How to Create Your First Approval Process in Salesforce
  • Controlling Fields – It is able to control the available values in one or more corresponding dependent fields.
  • Dependent Fields – It is able to display the values based on the values selected for the correspondent controlling fields. In the case of the above example, the country will be the controlling field and the state will be the dependent field. The controlling field is the checkbox and the dependent field is always a picklist.

More considerable facts for dependent fields –

  • The values that are selected for the controlling fields have a direct impact on the dependent field.
  • Both dependent fields and controlling fields work in conjunction with the filtration of values.
  • The custom picklists can either be defined as the controlling fields of dependent fields.
  • The standard picklist is usually defined as the controlling fields only and we cannot define then as dependent fields.
  • The default values can be defined for controlling fields only not for the dependent fields.
  • The checkbox can be defined as controlling fields, not the dependent fields.
  • The multi-select picklist can be defined as the dependent fields not controlling fields.

With these important points, you must have a clear idea of controlling fields and the dependent fields and how should you define them for Field Dependency Salesforce.

Register for online Salesforce training classes now to know all about Field dependencies in detail.

Salesforce Training For Administrators & Developers

  • Personalized Free Consultation
  • Access to Our Learning Management System
  • Access to Our Course Curriculum
  • Be a Part of Our Free Demo Class

How to Create Field Dependencies in Salesforce?

To learn how to create field dependency in Salesforce, Login to your Salesforce account. We are taking the example of healthcare products here and for the field dependency Salesforce.

Read: How to Update, Insert, Export or Delete Data Using Apex Data Loader?
  • In the first step, go to the Setup -> Build -> Create -> Objects -> Healthcare Product – Create Fields and Relationships -> Field Dependency.
  • From the Field dependency option, Click on New button.
  • As you can see that there are no field dependencies are defined for the healthcare products. Once you click the New option, the following screen will appear in front of you:
  • Here, you have to define the controlling field and dependent field for the healthcare product carefully. So, there is only one category and multiple sub-categories are defined for the same.
  • In the last step, click on the Save option. Congratulation, the field dependencies are created successfully for the healthcare product. In the same way, you can define the field dependencies for different products by following the step-by-step easy guide as discussed in this section.

Further, this is necessary to define which type of values you wanted to save in controlling fields and dependent field, it can be anything from a number to the alphabet or formulas etc. In the next section, we will discuss the complete list of data types for field dependencies and how they can be used to make the concept a little more relevant and useful for the users.

Register for a demo class to upgrade your Salesforce CRM skills!

Salesforce Training For Administrators & Developers

  • No cost for a Demo Class
  • Industry Expert as your Trainer
  • Available as per your schedule
  • Customer Support Available

A list of Data types for Field Dependency Salesforce Lightning

Auto-number This is a sequence number that is system dependent and using a display format. If you are planning to use this data type then the number will automatically increase by one for the next new record added.
Formula This is a read-only field that is taking its value from the formula expression. The value of the formula field will change automatically as soon as the value of the source field will be changed. With the help of a formula field, you can define the custom summaries based on reported data and the calculated values. Further, these formulas can also be used as the columns in the report.
Look relationship This field created the relationship with the help of which one object can be connected with the other. With the help of this relationship, you can always choose the lookup icon to select values from the pop-up list. The second object will be the source of value in the list.
Roll-up Summary This is again a read-only field that helps you to display the values like sums of numbers, maximum value from the list, minimum values from the list, the total count for all records and much more.
Master-Details Relationship As the name suggests, this relationship will define the master-slave relationship between objects or we can say parent-child relationships too. This is necessary to define the relationship field for almost all detail records. Once you have defined the relationship field and it has been saved then you cannot change it. The ownership for the field is further defined by the master record. If a user deleted the master record then a detailed record will be deleted automatically.

The roll-up summary fields can also be defined for the master record to summarize the detail record.

Read: A Detailed Guide on Salesforce Business Analyst Roles & Responsibilities in 2024

Avail our self-paced modules now to learn at your own place, speed, and comfort.

Learn Salesforce in the Easiest Way

  • Learn from the videos
  • Learn anytime anywhere
  • Pocket-friendly mode of learning
  • Complimentary eBook available

Checkbox With this field, you can always select true or false values for the objects. The checkbox values can be defined as controlling fields, not the dependent fields.
Currency With the help of a currency field, you could enter the amount in different currencies like Dollars, Indian rupees or more. This is also useful in exporting data to the excel file or other spreadsheets.
Date With the help of this field, you can always enter the data or pick the date from the popup calendar.
Date / Time The next popular data type is the Date/time field where you can pick both either date or time from the popup calendar. The choice is up to you or it also depends on project requirements either you wanted to use the date field only or you wanted to add date/time both.
Email This field will allow users to enter an email address and validate the data in the proper format. If the field is defined as lead or contact, the address will be picked up automatically based on records. Keep in mind that custom email addresses cannot be used for mass emails.
Percent What to do if you wanted to add a percent number? With the help of percent data type, the sign of percentage will be automatically added to the number but make sure that fields are marked as percent during declaration.
Phone Give flexibility to users so that they could add phone numbers automatically in the proper format either mobile number or the landline.
Number With this data type, you can add any type of number but the leading zeros are removed later when you store the values.
Picklist With the help of this data type, one value can be picked from a long list defined by the user. In a few cases, there is the freedom to select multiple values too, if the multi-select option for the picklist is validated.
Text As the name suggests, it will allow users to add letters, numbers or the combination of letters or numbers too. It is common in the case of user id or passwords.
Text areas With this data type, you can limit the count of characters that can be entered by the user in the given space. In most cases, it is 255 characters only. You can define the long text areas too where users are allowed to enter up to 32,768 characters or more.   With the rich text area option, users are allowed to enter formatted text, images or links, etc. next is encrypted Text area where values are added in the form of text or numbers and it is stored in the encrypted format.
URL with this data type, users are allowed to add any valid email address. As soon as users click on the link, it will open in a separate browser.

Final Words:

With this discussion, you have complete information about Field dependency in Salesforce, how to create Field dependency in Salesforce and different data types for field dependency Salesforce, etc. Once you will go through each of the sections carefully, you can quickly start using them practically and don’t forget to validate the values ahead. I hope you enjoyed reading this Salesforce dependencies blog and learned something new with this blog post. Don’t forget to share your experience with us!

Read: All You Need to Know About Salesforce Administrator


Salesforce Tutorial Overview

fbicons FaceBook twitterTwitter lingedinLinkedIn pinterest Pinterest emailEmail

     Logo

    JanBask Training

    A dynamic, highly professional, and a global online training course provider committed to propelling the next generation of technology learners with a whole new way of training experience.


  • fb-15
  • twitter-15
  • linkedin-15

Comments

Trending Courses

Cyber Security Course

Cyber Security

  • Introduction to cybersecurity
  • Cryptography and Secure Communication 
  • Cloud Computing Architectural Framework
  • Security Architectures and Models
Cyber Security Course

Upcoming Class

-0 day 12 Oct 2024

QA Course

QA

  • Introduction and Software Testing
  • Software Test Life Cycle
  • Automation Testing and API Testing
  • Selenium framework development using Testing
QA Course

Upcoming Class

14 days 26 Oct 2024

Salesforce Course

Salesforce

  • Salesforce Configuration Introduction
  • Security & Automation Process
  • Sales & Service Cloud
  • Apex Programming, SOQL & SOSL
Salesforce Course

Upcoming Class

-0 day 12 Oct 2024

Business Analyst Course

Business Analyst

  • BA & Stakeholders Overview
  • BPMN, Requirement Elicitation
  • BA Tools & Design Documents
  • Enterprise Analysis, Agile & Scrum
Business Analyst Course

Upcoming Class

-0 day 12 Oct 2024

MS SQL Server Course

MS SQL Server

  • Introduction & Database Query
  • Programming, Indexes & System Functions
  • SSIS Package Development Procedures
  • SSRS Report Design
MS SQL Server Course

Upcoming Class

-0 day 12 Oct 2024

Data Science Course

Data Science

  • Data Science Introduction
  • Hadoop and Spark Overview
  • Python & Intro to R Programming
  • Machine Learning
Data Science Course

Upcoming Class

-0 day 12 Oct 2024

DevOps Course

DevOps

  • Intro to DevOps
  • GIT and Maven
  • Jenkins & Ansible
  • Docker and Cloud Computing
DevOps Course

Upcoming Class

6 days 18 Oct 2024

Hadoop Course

Hadoop

  • Architecture, HDFS & MapReduce
  • Unix Shell & Apache Pig Installation
  • HIVE Installation & User-Defined Functions
  • SQOOP & Hbase Installation
Hadoop Course

Upcoming Class

13 days 25 Oct 2024

Python Course

Python

  • Features of Python
  • Python Editors and IDEs
  • Data types and Variables
  • Python File Operation
Python Course

Upcoming Class

7 days 19 Oct 2024

Artificial Intelligence Course

Artificial Intelligence

  • Components of AI
  • Categories of Machine Learning
  • Recurrent Neural Networks
  • Recurrent Neural Networks
Artificial Intelligence Course

Upcoming Class

-0 day 12 Oct 2024

Machine Learning Course

Machine Learning

  • Introduction to Machine Learning & Python
  • Machine Learning: Supervised Learning
  • Machine Learning: Unsupervised Learning
Machine Learning Course

Upcoming Class

34 days 15 Nov 2024

 Tableau Course

Tableau

  • Introduction to Tableau Desktop
  • Data Transformation Methods
  • Configuring tableau server
  • Integration with R & Hadoop
 Tableau Course

Upcoming Class

13 days 25 Oct 2024

Search Posts

Reset

Receive Latest Materials and Offers on Salesforce Course

Interviews