Shun Kosaka
October 31, 2019
800

# 試して学ぶ数式項目・入力規則 / Salesforce Formulas and Validation Rules Hands on

October 31, 2019

## Transcript

2. ### ✏ Salesforce Trailhead Playground Developer Edition 1 ✋ • •

• https://sli.do/ # 8230 2019 10 31 Salesforce TERAKOYA FORCE (Advanced + )

4. ### IF(AND(ISBLANK(Terakoya_c), IsActive = true ), ‘ ’, ‘ ’ )

IF( AND( ISBLANK(Terakoya__c), IsActive = true ), ‘ ’, ‘ ’ ) https://help.salesforce.com/articleView?id=customize_formula_best_practices.htm&type=5 ( ) IF AND OR CASE • • = true

edDate ) /
7. ### / Step2. / MONTH(LastModi edDate ) = MONTH(DATEVALUE(LastModi edDate)) =

12 DATEVALUE(2017/12/18 16:10) = 2017/12/18 STEP1 MONTH
8. ### / Step3. ❌ MONTH(DATEVALUE(LastModi edDate)) & ⭕ MONTH(DATEVALUE(LastModi edDate)) &

& = 12 ( ) ( ) NG 12 ( ) ( ) Apex + +
9. ### / Step4. / TEXT(12) = 12 MONTH(DATEVALUE(LastModi edDate)) & =

TEXT(MONTH(DATEVALUE(LastModi edDate))) & = 12 & = 12
10. ### 1. • • 2. • 3. ❌ ⭕ ☺ Owner.ProﬁleId

= ’0e28000001qLOa’ …

13. ### 1 OK NG AND( ISPICKVAL(PRIORVALUE(StageName), ‘Value Proposition’), OR( ISPICKVAL(StageName, ‘Needs

Analysis’), ISPICKVAL(StageName, ‘Qualiﬁcation’), ISPICKVAL(StageName, ‘Prospecting’) ) ) Value Proposition …
14. ### 1 OK NG AND( ISPICKVAL(PRIORVALUE(StageName), ‘Value Proposition’), OR( ISPICKVAL(StageName, ‘Needs

Analysys’), ISPICKVAL(StageName, ‘Qualiﬁcation’), ISPICKVAL(StageName, ‘Prospecting’) ) ) Value Proposition …
15. ### 1 CASE(StageName, ‘Prospecting’, 1, ‘Qualiﬁcation, 2, ‘Needs Analysis, 3, …

… ‘Closed Won’, 9, ‘Closed Lost’,9, 0 ) CASE(PRIOVALUE(StageName), ‘Prospecting’, 1, ‘Qualiﬁcation, 2, ‘Needs Analysis, 3, … … ‘Closed Won’, 9, ‘Closed Lost’, 9, 0 ) 1 2 3 4 5 6 7 8 9 CASE 0縄 OK

20. ### 2 ( ) • • • • • Apex •

( ) • Sandbox •
21. ### 3 ( ) ⭕ ⭕ ⭕ ⭕ ⭕ ❌ ❌

ShippingState <> ‘ ’ || ShippingState <> ‘ ’ || ShippingState <> ‘ ’ || … 44 … …
22. ### 3 ( ) NOT( CONTAINS( ‘ : : : :

: : : : : : : : : : : : : 結 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : ’ , ShippingState ) ) || LEN(ShippingState) < 3 = ShippingState 3 ( ) OR IF CONTAINS