Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
試して学ぶ数式項目・入力規則 / Salesforce Formulas and Validation Rules Hands on
Shun Kosaka
October 31, 2019
Technology
2
710
試して学ぶ数式項目・入力規則 / Salesforce Formulas and Validation Rules Hands on
Shun Kosaka
October 31, 2019
Tweet
Share
More Decks by Shun Kosaka
See All by Shun Kosaka
プロセスビルダーの設計書を生成しよう / Document Your Process
shunkosa
0
410
はじめてのCommunity Cloudデータセキュリティ / Community Cloud Data Sharing Basic
shunkosa
1
550
Lightning Web ComponentでチャットのUIをカスタマイズしよう / Enhance Chat UI with LWC
shunkosa
0
590
JP Salesforce SAML SSO for Beginners
shunkosa
0
510
Testing Lightning Flow
shunkosa
0
390
Schedule Your Process Without Coding
shunkosa
0
440
Service Cloud Omni-Channel Basics and New Features
shunkosa
0
560
Other Decks in Technology
See All in Technology
要約 "Add Live Text interaction to your app"
ushisantoasobu
0
140
スタートアップと技術選定と AWS
track3jyo
PRO
0
210
Build 2022で発表されたWindowsアプリ開発のあれこれ振り返ろう
hatsunea
1
370
1人目SETとして入社して2ヶ月の間におこなったこと
tarappo
3
520
How to start with DDD when you have a Monolith
javujavichi
0
210
UIKitのアップデート #WWDC22
akatsuki174
3
190
サイボウズの アジャイル・クオリティ / Agile Quality at Cybozu
cybozuinsideout
PRO
4
2.1k
Microsoft Build 2022 Recap Party!! Azure のデータ & 分析サービス 注目アップデート / microsoft-build-2022-recap-azure-data-and-analytics
nakazax
0
250
OPENLOGI Company Profile
hr01
0
320
Camp Digital 2022: tailored advice
kyliehavelock
0
140
Custom GitHub Actions by Java
kazamori
0
280
JAWS-UG re:Habilitaion 報告 / JAWS-UG OITA rehabilitation
hiranofumio
0
110
Featured
See All Featured
Web Components: a chance to create the future
zenorocha
303
40k
Three Pipe Problems
jasonvnalue
89
8.7k
Making the Leap to Tech Lead
cromwellryan
113
7.4k
Testing 201, or: Great Expectations
jmmastey
21
5.4k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
351
21k
Building a Scalable Design System with Sketch
lauravandoore
448
30k
What's new in Ruby 2.0
geeforr
336
30k
Thoughts on Productivity
jonyablonski
43
2.3k
The Pragmatic Product Professional
lauravandoore
19
3k
Six Lessons from altMBA
skipperchong
14
1.4k
Design by the Numbers
sachag
271
17k
Raft: Consensus for Rubyists
vanstee
126
5.4k
Transcript
& TERAKOYA EAST Shun Kosaka | Accenture Japan | @shunkosa
✏ Salesforce Trailhead Playground Developer Edition 1 ✋ • •
• https://sli.do/ # 8230 2019 10 31 Salesforce TERAKOYA FORCE (Advanced + )
[ ] … 1. 2. 3.
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
/
Step1. Help MONTH(2017/12/18) = 12 ❌ MONTH(LastModi edDate) ⭕ MONTH(LastModi
edDate ) /
/ Step2. / MONTH(LastModi edDate ) = MONTH(DATEVALUE(LastModi edDate)) =
12 DATEVALUE(2017/12/18 16:10) = 2017/12/18 STEP1 MONTH
/ Step3. ❌ MONTH(DATEVALUE(LastModi edDate)) & ⭕ MONTH(DATEVALUE(LastModi edDate)) &
& = 12 ( ) ( ) NG 12 ( ) ( ) Apex + +
/ Step4. / TEXT(12) = 12 MONTH(DATEVALUE(LastModi edDate)) & =
TEXT(MONTH(DATEVALUE(LastModi edDate))) & = 12 & = 12
1. • • 2. • 3. ❌ ⭕ ☺ Owner.ProfileId
= ’0e28000001qLOa’ …
ON ( ) PRIORVALUE
1. Playground Developer Edition 2. packaging/installPackage.apexp?p0=04t2v000005aNhH 3. URL lightning.force.com/ 2
https://brave-badger-180775-dev-ed.lightning.force.com/packaging/instalackage.apexp?p0=04t2v000005aNhH URL OK 4.
1 OK NG AND( ISPICKVAL(PRIORVALUE(StageName), ‘Value Proposition’), OR( ISPICKVAL(StageName, ‘Needs
Analysis’), ISPICKVAL(StageName, ‘Qualification’), ISPICKVAL(StageName, ‘Prospecting’) ) ) Value Proposition …
1 OK NG AND( ISPICKVAL(PRIORVALUE(StageName), ‘Value Proposition’), OR( ISPICKVAL(StageName, ‘Needs
Analysys’), ISPICKVAL(StageName, ‘Qualification’), ISPICKVAL(StageName, ‘Prospecting’) ) ) Value Proposition …
1 CASE(StageName, ‘Prospecting’, 1, ‘Qualification, 2, ‘Needs Analysis, 3, …
… ‘Closed Won’, 9, ‘Closed Lost’,9, 0 ) CASE(PRIOVALUE(StageName), ‘Prospecting’, 1, ‘Qualification, 2, ‘Needs Analysis, 3, … … ‘Closed Won’, 9, ‘Closed Lost’, 9, 0 ) 1 2 3 4 5 6 7 8 9 CASE 0縄 OK
2 • (TERAKOYA) • a IF(Account.ShippingState = , 500, 700)
2 • (TERAKOYA) • a IF(Account.ShippingState = , 500, 700)
2 • (TERAKOYA) • a IF(Account.ShippingState = , 500, 700)
2 Label Cost__c DeveloperName 500 Tokyo 600 Kanagawa 700 Others
IF( Account.ShippingState = $CustomMetadata.Terakoya_Shipping_Cost__mdt.Tokyo.MasterLabel, $CustomMetadata.Terakoya_Shipping_Cost__mdt.Tokyo.Cost__c, $CustomMetadata.Terakoya_Shipping_Cost__mdt.Others.Cost__c ) (Terakoya_Shipping_Cost__mdt)
2 ( ) • • • • • Apex •
( ) • Sandbox •
3 ( ) ⭕ ⭕ ⭕ ⭕ ⭕ ❌ ❌
ShippingState <> ‘ ’ || ShippingState <> ‘ ’ || ShippingState <> ‘ ’ || … 44 … …
3 ( ) NOT( CONTAINS( ‘ : : : :
: : : : : : : : : : : : : 結 : : : : : : : : : : : : : : : : : : : : : : : : : : : : : ’ , ShippingState ) ) || LEN(ShippingState) < 3 = ShippingState 3 ( ) OR IF CONTAINS
4 2 10% 8% ※ (TERAKOYA) ID API (DeveloperName)
5 (TERAKOYA) 30%縄
5 ※ TERAKOYA
https://gist.github.com/shunkosa/acf995909947d95174cd7ae5252ae4dd
• • ID • DeveloperName • • • • •
Trailhead Salesforce Help - https://help.salesforce.com/articleView?id=useful_advanced_formulas.htm&type=5
Thank you!