-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
4Questions
-
2Replies
Publisher Action to Change Owner
The standard publisher actions don't allow us to change the owner of a record. Does anyone have code to do that?
- Cheryl Besch
- December 01, 2014
- Like
- 0
- Continue reading or reply
Asset History Tracking using PRIORVALUE Field
Since Assets don't allow for history tracking on fields, I am trying to create a long text field that tracks the values of these fields. I have it pretty much worked out except for the picklist fields.
Here is my Workflow Rule:
OR(
ISCHANGED( AccountId ),
ISCHANGED( ContactId),
ISCHANGED( SerialNumber ),
ISCHANGED( Serial_Number_2__c ),
ISCHANGED( Hardware_Status__c ),
ISCHANGED( Hardware_Model_iSC1__c),
ISCHANGED( Hardware_Model_iSC2__c )
)
Here is my Field Update:
"Asset changed from " +
PRIORVALUE(AccountId) + "to " + AccountId + BR() +
PRIORVALUE( ContactId ) + "to " + ContactId + BR() +
PRIORVALUE( SerialNumber )+ "to " + SerialNumber + BR() +
PRIORVALUE( Serial_Number_2__c )+ "to " + Serial_Number_2__c + BR() +
PRIORVALUE( Hardware_Status__c ) + "to " + TEXT(Hardware_Status__c) + BR() +
PRIORVALUE( Hardware_Model_iSC1__c ) + "to " + TEXT(Hardware_Model_iSC1__c) + BR() +
PRIORVALUE( Hardware_Model_iSC2__c ) + "to " + TEXT(Hardware_Model_iSC2__c) + BR() + "by " +
LastModifiedById + BR() +
PRIORVALUE(Asset_History_Log__c)
The problem lies in the values the picklists are returning are not the actual PRIORVALUE, it is returning the picklist number(see bold below).
11to In Storage - New
1to ISC250-01P1227A
1to ISC250-01T2394A
Thoughts on how I can get the actual value to return? Thanks,
Here is my Workflow Rule:
OR(
ISCHANGED( AccountId ),
ISCHANGED( ContactId),
ISCHANGED( SerialNumber ),
ISCHANGED( Serial_Number_2__c ),
ISCHANGED( Hardware_Status__c ),
ISCHANGED( Hardware_Model_iSC1__c),
ISCHANGED( Hardware_Model_iSC2__c )
)
Here is my Field Update:
"Asset changed from " +
PRIORVALUE(AccountId) + "to " + AccountId + BR() +
PRIORVALUE( ContactId ) + "to " + ContactId + BR() +
PRIORVALUE( SerialNumber )+ "to " + SerialNumber + BR() +
PRIORVALUE( Serial_Number_2__c )+ "to " + Serial_Number_2__c + BR() +
PRIORVALUE( Hardware_Status__c ) + "to " + TEXT(Hardware_Status__c) + BR() +
PRIORVALUE( Hardware_Model_iSC1__c ) + "to " + TEXT(Hardware_Model_iSC1__c) + BR() +
PRIORVALUE( Hardware_Model_iSC2__c ) + "to " + TEXT(Hardware_Model_iSC2__c) + BR() + "by " +
LastModifiedById + BR() +
PRIORVALUE(Asset_History_Log__c)
The problem lies in the values the picklists are returning are not the actual PRIORVALUE, it is returning the picklist number(see bold below).
11to In Storage - New
1to ISC250-01P1227A
1to ISC250-01T2394A
Thoughts on how I can get the actual value to return? Thanks,
- Cheryl Besch
- June 10, 2014
- Like
- 0
- Continue reading or reply
Validation rule based on Opportunity Stage Picklist and User
We want to restrict all but one user from changing the stage of an opportunity to Closed/Won. Here is my formula below. Any suggestions?
AND(
$User.Id="00540000002WHSSAA4",
ISCHANGED(StageName),
ISPICKVAL(StageName,"80 - Closed/Won"))
AND(
$User.Id="00540000002WHSSAA4",
ISCHANGED(StageName),
ISPICKVAL(StageName,"80 - Closed/Won"))
- Cheryl Besch
- May 14, 2014
- Like
- 0
- Continue reading or reply
On the standard Case object, I have a custom lookup field that I am trying to populate....It links to the User object and is called "Case_Coordinator__c".
I'm trying to create a trigger that populates this field if it is left blank. It should populate with the Case Owner as a default.
- Cheryl Besch
- May 09, 2014
- Like
- 0
- Continue reading or reply
Validation rule based on Opportunity Stage Picklist and User
We want to restrict all but one user from changing the stage of an opportunity to Closed/Won. Here is my formula below. Any suggestions?
AND(
$User.Id="00540000002WHSSAA4",
ISCHANGED(StageName),
ISPICKVAL(StageName,"80 - Closed/Won"))
AND(
$User.Id="00540000002WHSSAA4",
ISCHANGED(StageName),
ISPICKVAL(StageName,"80 - Closed/Won"))
- Cheryl Besch
- May 14, 2014
- Like
- 0
- Continue reading or reply