Mindmajix

How to Create Field Dependence in SalesForce

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:

             Screenshot_159

Country Australia India US
State AUS1 AUS1 IND1
  AUS2 AUS2 IND2
  AUS3 AUS3 IND3
  IND1 IND1 AUS1
  IND2 IND2 AUS2
  IND3 IND3 AUS3
  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.

   ↓

Save

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. LOOKUP 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 DETAIL 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.

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.

Enroll for Live Instructor Led Online SalesForce Training


0 Responses on How to Create Field Dependence in SalesForce"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.