Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
試して学ぶ数式項目・入力規則 / Salesforce Formulas and Valida...
Search
Shun Kosaka
October 31, 2019
Technology
3
1.4k
試して学ぶ数式項目・入力規則 / 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
1.6k
はじめてのCommunity Cloudデータセキュリティ / Community Cloud Data Sharing Basic
shunkosa
1
1.2k
Lightning Web ComponentでチャットのUIをカスタマイズしよう / Enhance Chat UI with LWC
shunkosa
0
1.4k
JP Salesforce SAML SSO for Beginners
shunkosa
0
1.1k
Testing Lightning Flow
shunkosa
0
750
Schedule Your Process Without Coding
shunkosa
0
650
Service Cloud Omni-Channel Basics and New Features
shunkosa
0
940
Other Decks in Technology
See All in Technology
「Chatwork」のEKS環境を支えるhelmfileを使用したマニフェスト管理術
hanayo04
1
400
ソフトウェアテストのAI活用_ver1.25
fumisuke
1
610
american aa airlines®️ USA Contact Numbers: Complete 2025 Support Guide
aaguide
0
500
大量配信システムにおけるSLOの実践:「見えない」信頼性をSLOで可視化
plaidtech
PRO
0
390
AI エージェントと考え直すデータ基盤
na0
20
7.9k
衛星運用をソフトウェアエンジニアに依頼したときにできあがるもの
sankichi92
1
1k
安定した基盤システムのためのライブラリ選定
kakehashi
PRO
3
130
Amplify Gen2から知るAWS CDK Toolkit Libraryの使い方/How to use the AWS CDK Toolkit Library as known from Amplify Gen2
fossamagna
1
350
CDK Toolkit Libraryにおけるテストの考え方
smt7174
1
550
All About Sansan – for New Global Engineers
sansan33
PRO
1
1.2k
今だから言えるセキュリティLT_Wordpress5.7.2未満を一斉アップデートせよ
cuebic9bic
2
170
ABEMAの本番環境負荷試験への挑戦
mk2taiga
5
1.3k
Featured
See All Featured
Building Adaptive Systems
keathley
43
2.7k
Scaling GitHub
holman
460
140k
A better future with KSS
kneath
238
17k
Intergalactic Javascript Robots from Outer Space
tanoku
271
27k
GraphQLとの向き合い方2022年版
quramy
49
14k
Agile that works and the tools we love
rasmusluckow
329
21k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
3.1k
Designing for humans not robots
tammielis
253
25k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.4k
Gamification - CAS2011
davidbonilla
81
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!