官术网_书友最值得收藏!

How to do it...

Carry out the following steps to create a formula field to display Salesforce images to show graphically whether the close date is overdue or within date for Opportunity records:

  1. Click on the Setup gear icon in the top right-hand of the main Home page, as shown in the following screenshot:
  2. Click the Setup option, as shown in the following screenshot:
  1. Navigate to the Opportunity customization setup page, by clicking the following: Objects and Fields | Object Manager | Opportunity | Fields and Relationships.

Locate the Fields & Relationships section on the right of the page.

  1. Click New.

We will be presented with the Step 1. Choose the field type page.

  1. Select the Formula option.
  2. Click Next.

We will be presented with the Step 2. Choose output type page.

  1. Type Close Date Valid in the Field Label text box.
  2. Click on the Field Name. When clicking out of the Field Label text box, the Field Name is automatically filled with the value Close_Date_Valid.
  1. Set the Formula Return Type as Text.
  2. Click Next.

We will be presented with the Step 3. Enter formula page.

  1. Paste the following code:
/***********************************************************  
Warning Graphic for the Opportunity.  
If the Close Date has been reached display a warning  
***********************************************************/  
IMAGE(  
  IF(  
    AND(  
      NOT(IsClosed),  
      CloseDate < TODAY()),
      "/img/msg_icons/warning32.png",  
      "/img/msg_icons/confirm32.png"),  
      "", 15, 15) 
  1. Optionally, enter the following in the Description field:
 Field to display an image according to whether
the Close Date is overdue or within date
  1. Optionally, enter the following in the Help Text field:
 Field to display an image according to whether
the Close Date is overdue or within date
  1. In the Blank Field Handling section, select the option Treat blank fields as blanks.
  1. Click Next, as shown in the following screenshot:

We will be presented with the Step 4. Establish field-level security page.

  1. Select the profiles to which you want to grant read access to this field via field-level security. The field will be hidden from all profiles if you do not add it to field-level security.
  2. Click Next.

We will be presented with the Step 5. Add to page layouts page.

  1. Select the page layouts that should include this field. The field will be added as the last field in the first two column section of these page layouts. The field will not appear on any pages if you do not select a layout.
  2. Finally, click Save.
主站蜘蛛池模板: 广宗县| 于都县| 景谷| 广汉市| 甘孜县| 德保县| 乐亭县| 高淳县| 出国| 淄博市| 通山县| 东阳市| 通道| 河南省| 江永县| 巫山县| 富宁县| 巩留县| 正安县| 习水县| 桐梓县| 丹寨县| 忻城县| 兴化市| 任丘市| 什邡市| 民丰县| 冕宁县| 新巴尔虎左旗| 鹿邑县| 界首市| 漾濞| 锡林郭勒盟| 扬州市| 中超| 栾城县| 建平县| 龙山县| 昌都县| 边坝县| 泰和县|