Home  >  Blog  >   Salesforce

How to Create Field Dependence in SalesForce

Rating: 4.9
  1. Share:
Salesforce Articles

Field Dependence

Field dependencies are filters that allow us to change the contents of a pick list based on the value of another field.
For e.g.: rather than displaying every value for a country in a single pick list, we can limit the values that are displayed based on the value of another field like state. In this way users can find the appropriate country more quickly and easily.
A pick list field can be either controlling or dependent fields.
1) Controlling fields: controls the available values in one or more corresponding dependent field.
2) Dependent fields: displays values based on the value selected in its corresponding controlling field. In above e.g., the country is controlling field and state is dependent field.
Controlling field is a pick list or check box
Dependent field is a pick list

Creating Field Dependence:


Creating Field Dependence

Australia  IndiaUS
            AUS1            AUS1            AUS1            
            AUS2            AUS2            AUS2            
            IND1            IND1            IND1            
            IND2    IND2    IND2    
    IND3    IND3    IND3    
    US1    US1    US1    
    US2    US2    US2    
    US3    US3    US3    

               Include Values        Exclude values

Click buttons to include or exclude selected values from the dependent pick list.



Interested in mastering Salesforce? Enroll now for FREE Demo on Salesforce training

Data Types

1. Auto Number: A system-dependence sequence number that uses a display format. When you define the number, it is automatically incremented for each new record.
2. Formula: A read-only field that derives its value perform a formula expression you define the formula field is updated when any of the source fields change. Formulas let you create custom summaries based on calculated values using report data. These formulas can then be used as columns in your report.
3. Roll-Up Summary: A read-only field that displays the sum, minimum, or maximum value of a field in a related list or the record count of all records listed in a related list.
4. Look Relationship: Creates a relationship that links this object to another object. The field relationship allows users to click on a lookup icon to select a value from a popup list. The other object is the source of the values in the list.
5. Master Details Relationship: Creates a specific type of the parent child relationship between this object (the child, or “detail”) and another object (the parent or “master”) where:

  • The relationship field is required on all details records
  • Once the value of the relationship field has-been saved, it cannot be changed.
  • The ownership and sharing of a detail record are determined by the master record.
  • When a user deletes the master record, all details records are deleted.
  • You can create a roll-up summary fields on the master record to summarize the detail records.

MindMajix YouTube Channel

Explore Salesforce Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

The relationship fields allows users to click on a lookup icon to select a value from a popup list, the master objects is the source of the values in the list.
6. Check Box: Allow users to select a true (checked) or false (unchecked) value.
7. Currency: Allow users to enter a dollar or other currency amount and automatically formats the field as a currency amount. This can be useful if you export data to excel or another spreadsheet.
8. Date: Allow users to enter a date or pick a date from a popup calendar.
9. Date / Time: Allow users to enter a date and time or pick a date from popup calendar when users click a date in the popup, that date and current time are entered into the date/time field.
10. Email: Allow users to enter an email address, which is validated to ensure the proper format, if this field is specified for a contact or lead, users can choose the address when clicking send on email note, that custom email address cannot be used for mass emails.
11. Number: Allow users to enter any number. Leading zeros are removed.
12. Percent: Allow users to enter a percentage number, for example, 10 and automatically adds the percent sign to the number.
13. Phone: Allow users to enter any phone number automatically and format it is as a phone number.
14. Pick List: Allows users to select a value from a list, you define.
15. Pick List (Multi Select): Allows users to select multiple values from a list, you define.
16. Text: Allow users to enter any combination of letters and numbers.
17. Text Area: Allow users to enter up to 255 characters on separate lines.
18. Text Area (Long): Allow users to enter up to 32,768 characters on separate lines.
19. Text Area (Rich): Allow users to enter formatted text, and images and links up to 32,768 characters on separate lines.
20. Text (Encrypted): Allow users to enter any combination of letters and numbers and store them in encrypted from.
21. Url: Allow users to enter any valid website address. When users click on the field, the URL will open in a separate browser windows.

       Frequently Asked Salesforce Interview Questions & Answers

Mindmajix offers different Salesforce certification training according to your desire with hands-on experience on Salesforce concepts

Salesforce Administration TrainingSalesforce Lightning Training
Salesforce Advanced Developer TrainingSalesforce Developer Training
Salesforce IoT TrainingSalesforce App Builder Certification Training
Salesforce AppExchange TrainingSalesforce Service Cloud Training
and many more.. 


Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
Salesforce TrainingMay 21 to Jun 05View Details
Salesforce TrainingMay 25 to Jun 09View Details
Salesforce TrainingMay 28 to Jun 12View Details
Salesforce TrainingJun 01 to Jun 16View Details
Last updated: 28 Jul 2023
About Author

Arogyalokesh is a Technical Content Writer and manages content creation on various IT platforms at Mindmajix. He is dedicated to creating useful and engaging content on Salesforce, Blockchain, Docker, SQL Server, Tangle, Jira, and few other technologies. Get in touch with him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15