Skip to main content
Topics#Customer ServiceOtis Negel Bentick의 질문
Otis Negel Bentick (National Board Of Medical Examiners) 님이 #Customer Service에 질문했습니다
2020년 2월 10일 오전 12:05

Formula field on the Case Object that gets updated based on the values of other fields

I would like to create a formula field on the case object. The field is called "Closed By" This field should look at the case owner and the date/time closed field and then update the field with case owner when the case is closed. 

 

I am greatful for any help with this. 
답변 1개
  1. Anel Malabanan (Cloud Orca)
    2020년 2월 10일 오전 12:29
    Hi Negel,

     

    You need to create a Text field for ClosedBy then you need to create a Workflow or Process Builder to update ClosedBy field whenever the record is modified.

     

    Object

     

    Case

     

    when a record is created or edited

     

    Criteria

     

    Formula evaluates to true

    AND(
    ISPICKVAL([Case].Status, "Closed"),
    ISCHANGED([Case].Status)
    )

     

    Action

     

    Update Record

     

    Select the Case record that started your process

     

    Type: Formula

    [Case].Owner:User.FirstName &" "& [Case].Owner:User.LastName&" "&[Case].LastModifiedDate

     

    Hope it helps!
답변을 작성하세요...
0/9000