Skip to main content
Topics#Data ManagementSF Admin の質問
SF Admin (FreindshipWorks) が「#Data Management」で質問
2017年9月29日 19:38

How to Copy the Content of a Multi-picked Field before It Has Been Changed?

Due to History Tracking function can't record the changing content of a multi-pick field, so I would like to create a field to do it, I want to reserve the content from a multi-pick field before edited. For example, Field A was selected "111, 222", now I want to change Field A to "111, 333", but I would like to have Field B automatically records that the last content from Field A which is "111, 222". So after changes, Field A is "111, 333", and Field B is "111, 222". What formula should I use? Thanks
5 件の回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2017年9月29日 19:46

    You would need to create a Text field and then update it using a Workflow Rule or Process Builder using a Formula like this 

    IF(ISBLANK(PRIORVALUE(Multi_Picklist_1__c )), NULL, 
    SUBSTITUTE( 
    IF(INCLUDES(PRIORVALUE(Multi_Picklist_1__c), "Multi"), "Multi, ", NULL) + 
    IF(INCLUDES(PRIORVALUE(Multi_Picklist_1__c), "Picklist"), "Picklist, ", NULL) + 
    IF(INCLUDES(PRIORVALUE(Multi_Picklist_1__c), "Fields"), "Fields, ", NULL) + 
    IF(INCLUDES(PRIORVALUE(Multi_Picklist_1__c), "Suck"), "Suck, ", NULL) + ".", ", .", NULL))

     

     
回答を記入...
0/9000