To save others the time of hunting for the training material, it's here:
Winter ‘16 Administrator Release Exam (http://certification.force.com/pkb/articles/Public_KB/Winter-16-Administrator-Release-Exam/?q=winter+16&l=en_US&fs=Search&pn=1)
The modules are listed here:
Winter '16 Release Training for Certified Professionals (https://help.salesforce.com/HTTrainingModulesDetail?courseId=a1S300000032xGB)
Has anyone experience to deal with it ?
I am having trouble with a formula passing syntax - and further I am not sure it will work if I can get it to pass syntax.
This is what I need:
Email Alert if:
On an Opportunity where record type = x AND Opportunity is PO Received Won (Deal = Opportunity)
AND EITHER of the following 2 fields change:
- Estimated Delivery Date
ISPICKVAL( StageName , "PO Received Won Deal"),
RecordTypeId = "012A0000000Cz3S"
ISCHANGED( TotalOpportunityQuantity ),
ISCHANGED( Estd_deliv_Date__c )
Thanks for any help
You are missing a comma and a few parentheses.
Use this instead:
AND( ISPICKVAL( StageName , "PO Received Won Deal"), RecordTypeId = "012A0000000Cz3S", OR ( ISCHANGED( TotalOpportunityQuantity ), ISCHANGED( Estd_deliv_Date__c ) ) )
Provided you have your logic well thought out and in accordance with the requirement, it should work as expected.
There is field call" Question" on Case object, you can add it on the Case Page-layout so the case will get linked to Question automatically.
if our suggestion(s) worked, let us know by marking the answer as "Best Answer" right under the comment.This will help the rest of the community should they have a similar issue in the future. Thank you!
I am trying to create a validation rule that will check if multiple fields are filled in when the opportunity is at a specific sales stage
These are the fields as well as the data type
Potential_plan_signed__c - Date
Potential_Design_Sale__c - Picklist
Rating__c - Picklist
Sq_Ft__c - Number
Prix_Plans__c - Currency
O_Score_Project_Location__c - Picklist
O_Score_Tech_Complexity__c - Picklist
This is what I have so far; when I remove the 3 in bold the rule works.
ISPICKVAL(StageName, "5 - Offre de Service")
Thanks for your help
AND( TEXT(StageName) = "5 - Offre de Service", OR( ISBLANK(TEXT(Potential_Design_Sale__c)), ISBLANK(TEXT(Rating__c)), ISBLANK(TEXT(O_Score_Project_Location__c)), ISBLANK(TEXT(O_Score_Tech_Complexity__c)), ISBLANK(Potential_plan_signed__c), ISBLANK(Sq_Ft__c), ISBLANK(Prix_Plans__c) ) )
Please See the below screenshot and please refer the following link for the complete formula and explanation and you will also find other Common Date formulas there.
You just need to change the time (16:00 to some other value depending on your time zone and the difference between GMT and your time zone) the below formula works if you are in PDT
DATETIMEVALUE( '1900-01-08 16:00:00' )
with the Geolocation Fields you can calculate distances in Formula Fields. However, this requires some serious implementation time in your case.
Instead, you could look at applications from the AppExchange, which can help you with your mission:
Geopointe for example, allows you to indicate locations over all Standard and Custom Objects (and Standard and Custom Fields), and offers extensive analytic capabilities.
Hope this answers your question. If it does, please mark as best answer :-)
I'd like to be able to apply a validation rule to say:-
Must complete A field (checkbox) OR B field (date) in order to save record.
AND cannot complete both A AND B fields.
Appreciate any assistance, thank you.