ObjectiveResourcesKey Facts
Explain how to create custom fields.How to Create a Custom Field
[Could / 3m /]
List and describe the various custom field types.

Excluding: formula, roll-up summary, lookup relationship, and master-detail relationship fields (discussed in Objects).
Field Usage & Field Types
[Must / 10m /]

Custom Field Types
[Should / Medium /]

To view the remainder of this content, you must purchase the Certified Administrator Study Guide.  Please Login or purchase the study guide.


44 Responses to “Fields”

  1. mattl September 14, 2017 at 11:11 am #

    Hi John,

    With regards to the Global Pick-lists In lightning I can see a tick box to use a global pick list value set however I am not able to find the a place to create a global pick list value set? where do I find this?


    • mattl September 14, 2017 at 11:15 am #

      I think I have it.. you need to create a custom pick list, promote to global and then can reuse it?

  2. September 13, 2017 at 5:39 pm #

    Hi John,
    Think isn’t Beta versión “Supercharge Your Picklist Fields with Global Picklists (Beta)”

  3. spykiller July 29, 2017 at 12:21 pm #

    please I need help with this, getting conflicting answers!! What can be modified on standard object fields? pick 3
    Help text
    Default text
    Picklist values

    • JohnCoppedge July 31, 2017 at 12:33 pm #

      I would try modifying a standard picklist field and see what it lets you do…

      From memory, I believe it is help text, picklist values, and default value (if that’s what default text refers to, this isn’t properly worded)

      • mimou225 July 31, 2017 at 2:26 pm #


        i don’t think we can modify the default text on standard object. We can modify label in the “Rename Tabs and Labels” section.

  4. Yanfen232 March 5, 2017 at 6:48 pm #

    Hi, John can you clarify the below?
    I came across the below question and tended to select A although I think to make it “universally required” would be the right answer but its not an option to select. The corrected answer provided is “field level security”, which is not true as you can only make a field visible or not based on profiles but cannot make it required. Many others voted for the “validation Rules” arguing that page layout cannot make it required for everyone as its layout based. I’m now confused, is it page layout or validation rule?
    Which of the following is the best way to make the Field Mandatory for everyone?

    A. YY??Page Layout
    B. YY??Validation Rule
    C. Roles & Profiles
    D. Field Level Security

    • Whit1220 March 5, 2017 at 9:35 pm #

      If it is a custom field you can make it required in field settings or on page layout. If it’s a standard field it can be made required in page layout

    • JohnCoppedge March 7, 2017 at 4:40 pm #

      Yeah – its not a good question.

      Yes you could do this through the field definition itself and if you wanted this to apply in all circumstances (e.g. via API) then that would the best solution.

      Otherwise page layout or validation rule is the way.

  5. Sal March 3, 2017 at 11:55 pm #

    Which of the following is not an available function in the Formula Fields?

    A. HyperLink
    B. Substitute
    C. RPad
    D. Vlookup

  6. Whit1220 February 27, 2017 at 2:23 am #

    Hi John, can a custom formula field reference itself? Can they reference other custom formula fields? Thanks in advance for your help.

  7. Bhavesh_Lodaya December 8, 2016 at 7:04 am #

    The ‘Key Facts’ section for the Objectives “Describe the capabilities of Global Picklists.” and “Describe the implications of changing a picklist value.” is the same. I think the text is more relevant to the later. the former could be changed to “Global picklists let you efficiently reuse a single list of values for multiple custom picklist fields. Easily share picklists across objects by creating picklist fields that use a picklist value set from a global picklist. ”

    Just my 2 cents..

  8. nk005347 October 5, 2016 at 10:22 am #

    Hi John, You may review if you find link more suitable for explaining renaming tabs and field for standard objects

  9. mimou225 April 8, 2016 at 6:05 am #


    I find that salesforce intruduced the option “Strictly enforce picklist values” in picklist to Strictly enforce picklist values to enable validation of picklist values against the list of defined values. I think the second video in this page must be updated for this point.

  10. Bhavishya March 3, 2016 at 2:59 am #

    Hi John,

    I still didn’t understand what is an external object, external lookup from the Salesforce custom attribute documentation page. What is the difference between lookup and external lookup? Could you give me an example?

    • JohnCoppedge March 10, 2016 at 7:36 pm #

      Sure- lookup is internal to Salesforce. External lookup would look up to an outside database (e.g. sql server).

  11. nerd.sfdc March 1, 2016 at 11:32 am #

    I created venue object with ID and name and now I added that lookup on campaign being child record. I am struggling in lookup selection it shows ID being unique key but I want venue name on campaign form how do I do that

    • JohnCoppedge March 1, 2016 at 1:11 pm #

      To have name as the value that appears in a lookup, you need to use a text data type for the name/id of the object. You can’t have an auto-number and then display another value, unfortunately.

  12. nerd.sfdc February 28, 2016 at 9:38 am #

    Once we rename tabs it did not change referenced names example in contact view it is still showing account though I renamed tab to company

  13. Basil Dobek December 31, 2015 at 5:54 pm #

    Hey, any chance you can clarify the “Notes on Changing Custom Field Types” help, it seems to contradict itself. For example it starts by saying there are several types such as changing auto number to/from any other type looses data then explains the additional restriction that you can change to/from text. The article has many of these contradictions.

    • JohnCoppedge January 9, 2016 at 2:59 am #

      At the top it says that it CAN cause data loss- the bottom section is outlining the specific ways that data is lost. The auto-number to any field type does appear to be a contradiction though, as it says text is OK below. Technically speaking this is still accurate, as if you chose a text field that was too short (e.g. 5 characters), this would result in data loss.

      At the end of the day you probably aren’t going to be tested at this level of detail, and this is most certainly a change you would try first in a sandbox. That said, agree docs are a little fuzzy.

  14. October 2, 2015 at 3:56 pm #

    what is the use case of text encrypted and how another user will read that?

    • JohnCoppedge October 4, 2015 at 4:10 pm #

      Credit card, social security number, basically anything confidential that is partially or fully obfuscated once entered.


      User enters contact’s social security number. Once the record is saved, the user can only see the last 4 digits. However, the entire number is stored and visible to users with the permission that allows them to view encrypted fields.

  15. Robeela Ali March 6, 2015 at 9:20 am #

    Hi John,

    I am currently doing your course and finding it very useful I have been asked to complete the following task. I have imported the data from data Loader and could really do with you step by step help to complete this project. Can you help ?

    A customer has a list of leads they need imported. We need to import the leads and also create some views and rules/workflows to help them follow up the good ones.”
    1. Please import the list provided. there are various data loader tools you can use but I recommend you use the Salesforce DataLoader as it is the simplest.
    2. Create a new custom field on the lead object of type checkbox called “Call Requested”.
    3. Create a new formula field that will display “Please call” if the following two criteria are true: “Call Requested” is checked OR the Status field is “Hot”.
    4. Create a workflow rule that fires every time a lead status is “Hot” and emails a user with an alert and a link (I recommend you set this up with your own email and then once the whole thing is done you can change it to mine so I can see it working).
    5. Create a list view for the salesperson so that they can see all leads that need to be called. Please make sure that they can see the checkbox call needed on the list view and also that they are able to un-check it directly from the list view when they have called the lead.



    • JohnCoppedge March 6, 2015 at 2:02 pm #

      Can I provide step by step instructions? The short answer is no – however, this is a great learning opportunity. The content in this guide definitely covers all of these points, and you can do them in the order suggested. I would suggest that you try to work through each step in a dev org before you try it in production. This should get you more comfortable with the process. Good luck!

  16. Alex Messinger January 30, 2015 at 2:11 pm #

    Hi John-

    As Vishnuvardhan noted, I’m unclear on the differences between External, Indirect, and Lookup relationships. When I set up a custom field I only see a field type of “lookup” and not the other two.

  17. Vishnuvardhan Reddy December 6, 2014 at 8:21 am #

    Hi John,

    Can you please touch upon External, Indirect Lookup relationships and when and why they are used?

  18. Scott Waddell September 18, 2014 at 1:18 pm #

    Hi John,

    The link to the video that you’ve titled “How to Rename Standard Fields & Objects” actually points to a video talking about renaming and reordering Tabs. I looked through his Youtube channel and didn’t see a video about renaming standard fields and objects.

    • JohnCoppedge September 27, 2014 at 8:01 pm #

      When you rename the tab, you will get the option to rename the fields as well – the config is in the same spot.

  19. Algy George August 15, 2014 at 3:06 pm #

    How many externalIDs we can have per object?

  20. Thilaknath Ashok Kumar April 10, 2014 at 12:24 pm #

    Hi John Where have you discussed about Customer Portal?

Leave a Reply