Custom Fields.

In the Previous Page we discussed in brief about Custom Fields and Standard Fields. You have had a rough Idea about the table/object. Now lets take a step further and get familiar with the different types of field/colums that we can create in an object/table..Salesforce Custom Field Types are as below:

• Auto Number.  
• Formula.
• Lookup Relationship.
• Master-Detail Relationship.
• Checkbox.
• Currency.
• Date.Date/Time.
• Email.
• Geolocation.
• Number.
• Percent.
• Phone.
• Picklist.
• Picklist (Multi-Select).
• Text.
• Text Area.
• Text Area (Long).
• Text Area (Rich).  
• Text (Encrypted).
• URL.  

   Now Lets Discuss Each of them one by one.

 

   Auto Number:

When we have this field in the object/table a Unique Number is automatically assigned to the new record/row in the object/table. Suppose you have a requirement in which you have a Product Table and you wish to Provide a unique Identification to each product.. In this case we can use the Auto Number type. We can Provide the Display format as per our wish/requirement. This Link provides further detail on Display Format.    Formula.  A field whose value is calculated with the help of a formula. Suppose we have a requirement in which we have a requirement in which we are to Provide the expiry date of a product and the expiry date of the product is 6 months from the date of manufacture. So what we can do is that we can use the Standard field "Created Date" as the date of Manufacture and then a formula field that calculated the Expiry date as the 180 months after the Manufacture day.        Click on Advanced Formula Click on Insert Field. See the below screen Shot. Add 180 Click on Check Syntax. Click on Next. Make sure you are only checking the System Administrator  Profile  The other Fields will be covered in the next two pages.